Snowflake
Connection Parameters
Section titled “Connection Parameters”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 |
| 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) | ******** |
Authentication Methods
Section titled “Authentication Methods”Snowflake supports two authentication methods:
Password Authentication
Section titled “Password Authentication”Provide your Snowflake username and password. This is the simplest method for getting started.
Key-Pair Authentication
Section titled “Key-Pair Authentication”For enhanced security, use key-pair authentication:
- Generate your private key and encode it to Base64:
cat private_key.pem | base64 - Set Authenticator to
SNOWFLAKE_JWT - Paste the Base64-encoded key content in the Private Key field
- If your key is encrypted, provide the Private Key Password
Additional Notes
Section titled “Additional Notes”- Account identifier format varies by cloud provider and region
- Warehouse is required for query execution