Skip to content

Snowflake

When adding a Snowflake connection in Tracelake, you’ll need to provide the following information:

Parameter Type Required Description Example
Account Identifier String Yes Snowflake account identifier xy12345.us-east-1 or orgname-accountname
Username String Yes Snowflake username for authentication myuser
Password Password No Password for authentication (not required if using key-pair authentication) ********
Database String Yes Snowflake database name MYDB
Schema String Yes Snowflake schema name PUBLIC
Warehouse String Yes Snowflake warehouse name for compute resources COMPUTE_WH
Role String No Snowflake role to use for the session (optional, defaults to user’s default role) ANALYST_ROLE
Authenticator String No Authentication method (use ‘SNOWFLAKE_JWT’ for keypair authentication) SNOWFLAKE_JWT
Private Key (Base64) Textarea No Base64-encoded private key content for keypair authentication LS0tLS1CRUdJTi...
Private Key Password Password No Password for encrypted private key (leave blank if key is not encrypted) ********

Snowflake supports two authentication methods:

Provide your Snowflake username and password. This is the simplest method for getting started.

For enhanced security, use key-pair authentication:

  1. Generate your private key and encode it to Base64: cat private_key.pem | base64
  2. Set Authenticator to SNOWFLAKE_JWT
  3. Paste the Base64-encoded key content in the Private Key field
  4. If your key is encrypted, provide the Private Key Password
  • Account identifier format varies by cloud provider and region
  • Warehouse is required for query execution