​
Step 1: In the Data Portal, click Tables and then click Create Table.

​
Step 2: Select Snowflake as the Data Source.

​
Step 3: Create a New Connection.

Click New Connection. If you want to use an existing connection, select the connection from the list and proceed to Step 5.

Enter a Source Name for the new connection.

​
Step 4: Configure Connection Parameters

​
Connecting to Snowflake Using Basic Authentication

Use the following JSON configuration when Snowflake is set up with basic authentication using user and password.

{
  "sql.snowflake.account": "my_snowflake_account",
  "sql.snowflake.db": "my_database_name",
  "sql.snowflake.schema": "my_schema_name",
  "sql.snowflake.user": "my_username",
  "sql.snowflake.password": "my_secure_password"
}

​
Property Descriptions

PropertyRequiredDescription
sql.snowflake.accountYesThe name of the Snowflake account. Found in your Snowflake URL (e.g., xyz.snowflakecomputing.com).
sql.snowflake.dbYesThe name of the database where the data resides.
sql.snowflake.schemaYesThe name of the schema where the data resides.
sql.snowflake.userYesThe username for authenticating with Snowflake. Ensure the user has appropriate read access.
sql.snowflake.passwordYesThe password for authenticating with Snowflake.

​
Connecting to Snowflake Using Key Pair Authentication

Use the following JSON configuration when Snowflake is set up with Key Pair based authentication.

{
  "sql.snowflake.account": "my_snowflake_account",
  "sql.snowflake.db": "my_snowflake_db",
  "sql.snowflake.schema": "PUBLIC",
  "sql.snowflake.user": "my_username",
  "sql.snowflake.privateKey": "BASE64_ENCODED_PRIVATE_KEY",
  "sql.snowflake.privateKeyPassword": "BASE64_ENCODED_PASSWORD"
}

​
Property Descriptions

ParameterRequiredDescription
sql.snowflake.accountYesThe name of the Snowflake account. Found in your Snowflake URL (e.g., xyz.snowflakecomputing.com).
sql.snowflake.dbYesThe name of the database where the data resides.
sql.snowflake.schemaYesThe name of the schema where the data resides.
sql.snowflake.userYesThe username for authenticating with Snowflake. Ensure the user has appropriate read access.
sql.snowflake.privateKeyYesBase64-encoded private key for secure authentication
sql.snowflake.privateKeyPasswordYesBase64-encoded password for the private key

For more details, please refer to the Snowflake official documentation here

​
Step 5: Test the Connection and Configure Data Ingestion

After you have configured the connection properties, test the connection to ensure it is working.

When the connection is successful, use the following JSON to configure additional data settings:

{
  "sql.queryTemplate": "SELECT * FROM <TABLE> WHERE <TIME_COLUMN> BETWEEN $START AND $END",
  "sql.timeColumnName": "TIME_COLUMN",
  "sql.timeColumnFormat": "yyyy-MM-dd",
  "sql.startTime": "",
  "sql.endTime": ""
}

​
Property Descriptions

PropertyRequiredDescription
sql.queryTemplateYesThe SQL query template for fetching data from Snowflake.
sql.timeColumnNameYesThe time column used for filtering data while ingesting.
sql.timeColumnFormatYesThe datetime format of the time column used for filtering.
sql.startTimeYesThe start time for data extraction. Dynamically used in the $START placeholder of sql.queryTemplate. It should match the mentioned time column format.
sql.endTimeYesThe end time for data extraction. Dynamically used in the $END placeholder of sql.queryTemplate. It should match the mentioned time column format.

​
Additional Optional Parameters

Use the following JSON for optional configurations:

{
  "sql.bufferTimePeriod": "0d",
  "sql.numBucketsToLookBack": "0",
  "sql.bucketTimePeriod": "1d"
}

​
Optional Configuration Properties

PropertyRequiredDescription
sql.bufferTimePeriodNoThe buffer time period before fetching data. Default value: 0d. Defines additional time to consider before fetching data.
sql.bucketTimePeriodNoThe time period granularity for each data bucket. Default value: 1d.
sql.numBucketsToLookBackNoThe number of time buckets to look back when fetching data. Default value: 0. Used for incremental data fetching.

​
Step 6: Preview the Data

Click Show Sample Data to preview the source data before finalizing the configuration.