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.

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.

For Credentials, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection is FIPS-compliant and can be used on a FIPS-enabled cluster.

Running SQL statements

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