Snowflake

This page details how to use Snowflake as a Data Source when configuring a Data Sync.

1. Basic Parameters

In the Load Metadata pop-up (Image 1), enter the following information and click Load:

Parameter
Description

Connection String

This will be the encrypted connection string.

Unencrypted example: account=wr38353.ca-central-1.aws;user=myuser;password=mypassword;db=CINCHY;schema=PUBLIC You can review Snowflake's Connection String guide and parameter descriptions here.

Object

Select either Table or Query. If Table, a new field will appear to enter the table name. If Query, a new field will appear to enter a Select statement.

Image 1: Load your Metadata

2. Schema

  1. Add in your applicable column(s) (Image 2). See the documentation here for further details on each column type.

Image 2: The parameters for a standard column

3. Filters

You may choose to use CQL to create a filter (Image 3). Review the documentation here for more on filters.

Image 3: Adding a Source Filter

Last updated

Was this helpful?