Table Schema Change Detection for Data Governance and Security
This 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. Current version only works within one account, however a cross account version is being developed.
- Data Governance: Gain full control of 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.