# Schema Change Detection

Schema Change Detection helps you identify when your data has changed, and how it has done so. This can help catch unplanned changes, or let you know about new data you can use for analysis.

## Detected Events

Schema change detection currently surfaces the following changes:

* Table create / delete
* Column create / delete
* Column data type change

{% hint style="info" %}
Note: this information is processed from the schema metadata itself. If an object is renamed, this will be processed as a delete event with the old name and a create event with the new name.
{% endhint %}

## Schema Change Activities

All users can see schema change events directly on the tables themselves. Navigate to the **Overview** tab on a table. On the right hand side under History, users will be able to see the detected events for the table and for columns in that table.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-fd7da9c1566ccf4e35925d4c23452718d42fbc0a%2Fimage.png?alt=media" alt=""><figcaption><p>Column schema changes on a table</p></figcaption></figure>

Admins will be able to see *all* detected schema change activities on the Admin page under **Analytics > Schema Changes.**

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-9dd71fe842144fb7d6e8b67aee218ca7853c2b74%2Fimage.png?alt=media" alt=""><figcaption><p>Search for specific data assets across all schema changes</p></figcaption></figure>

## Notifications

Data asset owners (users and teams) will receive notifications when an asset the own has a detected schema change.

* In-app notifications will show all changes
* Email notifications will be sent per data source after ingestion (if configured)
* Slack notifications will be sent per data source after ingestion (if configured)

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-d971b52ccbe39ad880cdc4e64ac13d71b5263407%2Fimage.png?alt=media" alt=""><figcaption><p>Email notification for schema changes on Snowflake</p></figcaption></figure>

{% hint style="info" %}
Schema change notifications can be configured at the user, team or organization level. See [Slack Notifications](https://docs.selectstar.com/integrations/slack#slack-notifications) for more details.
{% endhint %}