Stacksync Documentation
  • What is Stacksync?
  • 🚀 Start here
    • Quick start
    • Community
  • 💡Guides
    • Modify Salesforce Data in Postgres
    • 🔄Two-way sync Salesforce and Postgres
      • Create a Postgres Database with Supabase (free forever)
      • Create a Salesforce Developer instance (free forever)
      • Create a Sync between Supabase Postgres and Salesforce
    • ⚡Event Triggers
    • 🔣Add a new custom field to an existing sync
  • 🔗 Connectors
    • Salesforce
      • Authorize Salesforce
        • ⚙️Enable API Access in Salesforce
    • Postgres
      • Authorize Postgres
        • Supabase
        • Cloud SQL
        • Digital Ocean
        • Heroku
        • Amazon Lightsail
        • Amazon RDS
        • Basedash
        • Render
      • Snippets
      • Required Permissions
    • BigQuery
      • Authorize BigQuery
    • HubSpot
      • Authorize HubSpot
      • Associations
    • Supabase
    • Snowflake
      • Authorize Snowflake
    • Attio
      • Authorize Attio
    • Pipedrive
      • Authorize Pipedrive
    • Front
      • Authorize Front
    • Zoho
      • Authorize Zoho
    • MySQL
      • Authorize MySQL
    • 🤖Setup options
      • 🏳️IP Whitelisting
      • 🚰Manage API rate limits
      • 🌍Choose data processing region
  • 📦 API Proxy
    • Salesforce
    • HubSpot
    • Attio
    • Pipedrive
  • Features
    • Two-way sync
    • Event triggers
      • Webhook (HTTP call)
      • Database Query
    • Update Base configuration
    • Foreign key support
    • Linked records field import
    • Manage API rate limits
    • Delete Record Protection
    • Other features
      • Base statistics
      • Monitoring
    • Security
      • SSO & SCIM
        • Azure Entra ID
        • OKTA
      • MFA
  • Legal
    • Terms of Service and Conditions (TC)
    • Privacy Notice
    • Service Consumption Tables
    • Global Employee and Applicant Privacy Notice
    • Acceptable Use Policy (AUP)
    • Data Processing Addendum (DPA)
    • Referral Programme Policy
    • Terms and Conditions for Stacksync Content Creator Programme
    • Stacksync Certified Partner Program Terms and Conditions
  • Security
    • Overview
    • Subprocessors
    • EU Data Protection
  • Others
    • Content Creator Guidelines
Powered by GitBook

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:

ObjectStatus

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().

PreviousSupabaseNextAuthorize Snowflake

Last updated 1 month ago

On this page
  • Introduction
  • Supported Objects
  • Things to keep in mind
Page cover image