Stacksync Documentation
Ask or search…
K

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 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!

Supported Objects

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