Snowflake connection

To access your data in Snowflake, create a connection asset for it.

Create a connection to Snowflake

Create a connection to Snowflake based on your deployment:

To create the connection, you need the following connection details:

Account name: The full name of your account
Database name
Role: The default access control role to use in the Snowflake session
Warehouse: The virtual warehouse
Okta URL endpoint: If your company uses native Okta SSO authentication, enter the Okta URL endpoint for your Okta account. Example: https://<okta_account_name>.okta.com. Leave this field blank if you want to use the default authentication of Snowflake. For information about federated authentication provided by Okta, see Native SSO.

To create a connection to use in StreamSets flows, you need the following details:

Account name: When using the Include Organization and Organization properties, specify the account name. Otherwise, use the account locator.
Database name
Role: The default access control role to use in the Snowflake session
Warehouse: The virtual warehouse
Snowflake region: The region where the Snowflake warehouse is
Connection properties: Additional Snowflake connection properties to use. Specify property names and values as expected by Snowflake.
Use Custom JDBC URL: A custom URL to connect to Snowflake
Include Organization: Use the Snowflake organization name with the account to connect to the Snowflake connection
Use Private Link Snowflake URL

Authentication method:

Username and password
Key-Pair: Enter the contents of the private key and the key passphrase (if configured). These properties must be set up by the Snowflake administrator. For information, see Key Pair Authentication & Key Pair Rotation in the Snowflake documentation.

For StreamSets, you have additional authentication methods:

Key-pair path: Enter the contents of the private key path and the key passphrase (if configured). These properties must be set up by the Snowflake administrator. For information, see Key Pair Authentication & Key Pair Rotation in the Snowflake documentation.
OAuth: Enter the OAuth client ID, secret and token

To ensure that your SQL statements run correctly, refer to the Snowflake SQL Command Reference for the correct syntax.