How Can I Track Schema Changes?

Use Case

You are looking for a detailed log of all of the schema changes that Fivetran makes in your destination.

Recommendation

Fivetran captures all the changes we make to your destination schemas and tables as events in the Fivetran Platform Connector.

You can query the data to find the schema and table changes, and when the change occurred:

1. Make sure that the Fivetran Platform Connector is running.

2. Query the LOG table for the following events:

   • create_schema: Schema created in destination
   • create_table: Table created in destination
   • drop_table: Table dropped from destination
   • alter_table: Table columns added to, modified in or dropped from destination table

3. (Optional) Create a view that tracks all of these events to identify schema changes.