Table Schema Change Detection for Data Governance and Security
This Treasure Workflow is intended to send a notice when an attempt is made to add new columns to data tables. It can be used when new data from any source is first going to a staging table before being appended to a final data table. It works within one account.
- Data Governance: Gain full control of a table schema preventing the addition of new columns without explicit consent.
- Data Security: Ensure PII is not inadvertently exposed in tables which should not have PII data.
- Data Consistency: Monitor data type changes to prevent inconsistent data.