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

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.

Salesforce Push Topic

Snowflake Source XML Example

Last modified 6mo ago