Manage schema changes
When your source adds or removes schemas, tables, or columns, Matia can detect and surface these changes. This guide explains how to control whether the integration automatically adopts them. For concepts, see ETL overview.
Where Schema Change Settings Live
- At creation: In step 3 (Configure) of Add Integration, under Schema changes.
- After creation: Open the integration → Settings tab → Schema changes section.
These options apply only to connectors that support schema change detection.
Schema Change Options
- Enable all schema changes automatically: New schemas, new tables, and new columns from the source are automatically added to the integration. Data from them is synced on the next run.
- Enable new columns and column changes only: New schemas and new tables are ignored. New columns on existing tables are added automatically; existing columns that change type may be handled according to connector behavior.
- Ignore all schema changes: New schemas, tables, and columns are not added. The integration continues to sync only the schema that existed when you last configured it.
Choose based on how tightly you want to control what is synced. Enabling all keeps the destination in step with the source; ignoring all keeps the integration fixed until you manually change it.
Reviewing Detected Changes
For integrations that support schema changes, a Schema changes tab appears on the integration details page. There you can see when Matia detected:
- Tables or columns added or removed
- Columns with type altered
Use this tab to review what changed before or after adjusting the global schema change setting. You can still enable or disable individual tables in the Schema tab.
Tip
If you use Enable new columns and column changes only, review the Schema changes tab periodically to see new tables you might want to enable manually.
For more on schema behavior and sync modes, see Sync modes.