What is Striim for Snowflake?
Striim for Snowflake is a fully-managed software-as-a-service tool for building data pipelines (see What is a Data Pipeline) to copy data from MariaDB, MySQL, Oracle, PostgreSQL, and SQL Server to Snowflake in real time using change data capture (CDC).
Striim first copies all existing source data to Snowflake ("initial sync"), then transitions automatically to reading and writing new and updated source data ("live sync"). You can monitor the real-time health and progress of your pipelines, as well as view performance statistics as far back as 90 days.
Optionally, with some sources, Striim can also synchronize schema evolution. That is, when you add a table or column to, or drop a table from, the source database, Striim will update Snowflake to match. Sync will continue without interruption. (However, if a column is dropped from a source table, it will not be dropped from the corresponding Snowflake target table.). If your source supports this, How would you like to handle schema changes? will appear among the Connect to Source properties.
When you launch Striim for Snowflake, we guide you through the configuration of your pipeline, including connecting to your Snowflake project, configuring your source, selecting the schemas and tables you want to sync to Snowflake, and choosing which settings to use for the pipeline.