Snowflake Table

1. Load Metadata

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.
Table
This will be the name of your target table. Ex: dbo.employees
Image 1: Load your Metadata

2. Basic Parameters

  1. 1.
    Add in information about your ID Column if applicable (Image 2):
Parameter
Description
ID Column
The name of the identity column that exists in the target (OR a single column that is guaranteed to be unique and automatically populated for every new record).
ID Column Data Type
Either: Text, Number, Date, Bool, Geography, or Geometry
Image 2: Basic parameters

3. Column Mappings

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

4. Filters

You may choose to use CQL to create a filter (Image 4). Review the documentation here for more on filters.
Image 4: Adding a Source Filter