Set Up Schema Drift Monitors

Here's how you set up a Schema Drift monitor.

Schema Drift Monitors are automatically activated for all tables upon connecting a data source. They identify alterations in the schema, such as the addition, deletion, or modification of tables or columns, and data type changes. Such adjustments can potentially lead to compatibility challenges with the corresponding database and the applications leveraging these tables.

Begin by selecting "Schema Drift" card from our config module landing page.

When you click on the "Schema Drift" card, it's important to begin by selecting the data source. Once the data source is chosen, a list of schema drift monitors from the selected data source will be seamlessly populated.

Schema Drift Monitors stands different from other monitor types. Unlike the usual practice, you cannot create or delete them. This uniqueness arises because Schema Drift Monitors are auto-generated whenever a new data source is added.

Modifying Monitors

When dealing with Schema Drift monitoring, users won't have the capability to create or set up monitors from scratch. Instead, the primary actions available are to modify and disable the existing schema drift monitors.

When modifying the settings for Schema Drift monitoring, you have the flexibility to configure various monitoring settings, including Incident Levels, the Notify function, and the ability to Set Custom Alerts for the following schema changes.

• Table Added

• Table Deleted

• Column Added

• Column Deleted

• Column Type Change