Supported Snowflake synchronization mechanisms¶

Snowflake operates on a continuous deployment model, meaning there are no traditional version numbers for its core platform. Instead, Snowflake automatically applies weekly updates, ensuring users always have access to the latest features and improvements without downtime. Sidra is designed to adapt to this model, maintaining compatibility with Snowflake’s latest updates and ensuring seamless integration as Snowflake evolves.

The Snowflake Connector for Sidra supports different data synchronization modes, allowing you to adapt to various needs and configurations in the source system or Sidra:

• Full load data synchronization:

Ideal for initial loads. This is also the default mode if no incremental load mechanism is configured. The first load will be a complete load by default.

• Incremental load data synchronization:

This method captures updates for any new or modified data from the Snowflake database, retrieving only the updates since the last synchronization. For incremental load to work, you need a defined mechanism to capture updates in the source system.