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
andACCOUNT_ADMIN
roles is required. TheSECURITY_ADMIN
role will be needed to create a Stacksync Role and User. TheACCOUNT_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()
.
Last updated