To enable regular synchronization of Snowflake metadata, complete the one-time setup steps: verify prerequisites, set up the JDBC connector, add the Catalog ingestion capability, and register the data source. After this setup, you can define synchronization rules for each schema and start manual or scheduled synchronization jobs.
| No. | Step | Description |
|---|---|---|
|
1 |
Key considerations to help ensure successful integration, including required Edge, Collibra, and data source-specific permissions. |
|
|
2 |
Sets up the JDBC Snowflake connector in an Edge or Collibra Cloud site. |
|
| 3 |
Add the Catalog JDBC ingestion capability for the Snowflake connection |
Adds the Catalog JDBC ingestion capability to the JDBC Snowflake connection and defines the extraction strategy for the integration. |
| 4 |
Before you can synchronize your data source, you have to register the data source to create an initial structure in a selected community in Data Catalog. |
|
| 5 | Configure the synchronization of the Snowflake data source. | After registering your data source, you need to configure the synchronization. For each schema, you can set up synchronization rules that define which tables are ingested and how. |
| 6 |
Synchronizing schemas is the process of updating the metadata of a registered data source in Collibra. You can synchronize a schema manually or automatically at fixed intervals. Once the data source is synchronized, the ingested Snowflake metadata is available. |
