Snowflake

Two-way sync between Snowflake and your other systems.

Introduction

Snowflake is a cloud-based data warehousing and analytics platform that enables users to analyze and process large data sets 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!

Supported Objects

Stacksync lets you sync the following Snowflake table types:

Object	Status
Standard tables (including Permanent, Transient and Temporary tables)	✅ Supported
Views (including materialized and non-materialized views)	🕘 Coming soon
External tables	❌ Not supported

All field types are supported except for geospatial datatypes (i.e. geography and geometry).

Things to keep in mind

• 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 not nullable and has a default value of UUID_STRING().