Two-way sync between Snowflake and your other systems.
Snowflake is a cloud-based data warehousing and analytics platform that enables users to analyze and process large datasets using SQL-like queries. It is highly scalable and allows users to store and query massive amounts of data in real-time.
Check out our Snowflake guides to get started and sync data to your other systems and databases!
Stacksync lets your sync the following Snowflake table types:
Standard tables (including Permanent, Transient and Temporary tables)
Views (including materialized and non-materialized views)
A Snowflake account with the SECURITY_ADMIN and ACCOUNT_ADMIN roles is required. The SECURITY_ADMIN role will be needed to create a Stacksync Role and User. The ACCOUNT_ADMIN will be needed to grant permissions to the Stacksync Role to grant access to the database and schemas, grant privilege to create schemas and tables in the specified database and allow read and write privilege to the tables in the specified database and schemas.
To sync an existing table from Snowflake, the table must have a primary key which is is not nullable and has a default value of UUID_STRING().