Configure schema drift alerts - Precisely Data Integrity Suite

Configure schema drift alerts to detect changes in table and column metadata. Schema drift rules generate alerts when tables or columns are added, deleted, renamed, or when column data types change.

1. Go to Observability > Observers and select + Create Observer.
2. On the Create Observer page, select your data assets and click Next.
3. In the Schema Drift row, click the gear icon in the Configure column.
4. For each schema change scenario, select an alert type.

   Schema change scenarios:

   • Table is deleted
   • Table is renamed
   • Column is deleted
   • Column is renamed
   • New column added
   • Column data type changed

   Alert types:

   • Critical: Generates a critical alert for high-impact schema changes.
   • Warning: Generates a warning alert for moderate-impact schema changes.
   • None: No alert is raised for this schema change.
   Tip: Select an alert type that reflects the criticality of the data. For example, if a specific table is very critical and can cause issues if deleted or renamed, set those scenarios to Critical Alert. For less critical changes like adding optional columns, you can select Warning Alert or None.
5. Click Save.