Synchronize Snowflake

Updated: June 5, 2026

To keep the content of Collibra synchronized with the schemas in the registered data source, you can:

Synchronize manually.
Synchronizing manually can be useful if you want to test your data source, or if you want to synchronize immediately.
Create a synchronization schedule to automatically synchronize with a fixed time interval.

Image of the full integration process, indicating you're in the final step 'Synchronize'

Prerequisites

Open a Database asset page.
In the tab bar, click Configuration.
In the Metadata Synchronization tab page, optionally click the Refresh List icon to get the latest schema information from the data source.
Do one of the following:
- To synchronize all schemas with a synchronization rule, click Synchronize Schemas with Rules.
- To synchronize a specific schema in the database:
  1. Select the schema.
  2. At the right of the schema name, click Synchronize Schema.
The synchronization job starts.
You can follow up on the synchronization job in real-time via the database synchronization report (in preview).
After the synchronization is completed, you can view a summary of the results to see the impact on the assets in Collibra. To do this, open the Activities list and click Result in the row for the related synchronization job. If changes occurred, you get details about the total number of resources added, modified or removed. If there are errors, details are provided.
The synchronization integrates tables, columns, foreign keys, and optionally views from the relevant schemas based on the configured synchronization rules.

Note

You can add only one synchronization schedule for all schemas of a data source. All schemas with synchronization rules will be synchronized at the specified intervals.
If you define a Cron expression to schedule the synchronization and the defined Cron expression expires, the Configuration tab page will show a notification.

Open a Database asset page.
In the tab bar, click Configuration.
In the Synchronization Schedule section of the Metadata Synchronization tab page, click Add Schedule to add a new schedule, or to edit an existing schedule.

Enter the required information.

Field	Description
Repeat	The interval when you want to synchronize automatically. The possible values are: Daily, Weekly, Monthly, and Cron expression.
Cron	The Quartz Cron expression that determines when the synchronization takes place. This field is only visible if you select `Cron expression` in the Repeat field.
Every	The day on which you want to synchronize, for example, Sunday. This field is only visible if you select `Weekly` in the Repeat field.
Every first	The day of the month on which you want to synchronize, for example, Tuesday. This field is only visible if you select `Monthly` in the Repeat field.
At	The time at which you want to synchronize automatically, for example, 14:00. You can only schedule on the hour. For example, you can add a synchronization schedule at 8:00, but not at 8:45. This field is only visible if you select `Daily`, `Weekly`, or `Monthly` in the Repeat field.
Time zone	The time zone for the schedule.

Click Save.
At the defined time, the synchronization job starts.
The synchronization integrates tables, columns, foreign keys, and optionally views from the relevant schemas based on the configured synchronization rules.
After the synchronization is completed, you can view a summary of the results to see the impact on the assets in Collibra. To do this, open the Activities list and click Result in the row for the related synchronization job. If changes occurred, you get details about the total number of resources added, modified or removed. If there are errors, details are provided.

Once the synchronization completes successfully, review the synchronized metadata.

From now on you can reconfigure the synchronization and synchronize the data source regularly.