Snowflake connection

Common connectivity

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.

StreamSets

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

Credentials

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.

Choose the method for creating a connection based on where you are in the platform

In a project

Click Assets > New asset > Connect to a data source. See Adding a connection to a project.

In a catalog

Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In a deployment space

Click Import assets > Data access > Connection. See Adding data assets to a deployment space.

In the Platform assets catalog

Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

• See Add data from a connection in a project.

• See Add data from a connection in a catalog.

Running SQL statements

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