snowflake-config

Configuration file for Snowflake

Type object
File match **/.snowflake/config.toml **/snowflake/config.toml
Schema URL https://catalog.lintel.tools/schemas/schemastore/snowflake-config/latest.json
Source https://www.schemastore.org/snowflake-config.json

Validate with Lintel

npx @lintel/lintel check
Type: object

Configuration for Snowflake

Properties

default_connection_name string

The default connection to use

connections Record<string, object>
cli object
2 nested properties
logs object

Configuration for logging

3 nested properties
save_logs boolean

Whether to save logs to a file

Default: true
level string

The level of logs to output

Default: "info"
Values: "debug" "info" "warning" "error"
path string

specifies the absolute path to save the log files. The format of the path varies based on your operating system. If not specified, the command creates a logs directory in the default config.toml file location.

features object

Configuration for features

1 nested properties
enable_separate_authentication_policy_id boolean

When this access is enabled, specified users can access Snowflake CLI but not the other Snowflake drivers.

Default: false

Definitions

Features object

Configuration for features

enable_separate_authentication_policy_id boolean

When this access is enabled, specified users can access Snowflake CLI but not the other Snowflake drivers.

Default: false
Logs object

Configuration for logging

save_logs boolean

Whether to save logs to a file

Default: true
level string

The level of logs to output

Default: "info"
Values: "debug" "info" "warning" "error"
path string

specifies the absolute path to save the log files. The format of the path varies based on your operating system. If not specified, the command creates a logs directory in the default config.toml file location.

SnowflakeConnection object

Configuration settings for connecting to a Snowflake database instance

account string

The Snowflake account identifier

Examples: "myaccount"
user string

The username to authenticate with Snowflake

Examples: "jondoe"
password string

The password for authentication with Snowflake

Examples: "******"
warehouse string

The name of the Snowflake warehouse to use for queries

Examples: "my-wh"
database string

The name of the Snowflake database to connect to

Examples: "my_db"
schema string

The name of the database schema to use

Examples: "my_schema"
role string

The name of the Snowflake role to use

authenticator string

The name of the Snowflake authenticator to use

Default: "snowflake"
Values: "externalbrowser" "id_token" "no_auth" "oauth" "oauth_client_credentials" "oauth_authorization_code" "okta" "programmatic_access_token" "snowflake_jwt" "snowflake" "tokenaccessor" "username_password_mfa" "workload_identity"
private_key_file string

The path to the private key file for the Snowflake JWT Authentication

private_key_file_pwd string

The password for the private key file for the Snowflake JWT Authentication

private_key_path string

The path to the private key file for the Snowflake Key Pair Authentication

private_key_passphrase string

The passphrase for the private key file for the Snowflake Key Pair Authentication

token_file_path string

The path to the token file for the Snowflake OAuth Authentication

workload_identity_provider string

The workload identity provider to use for WIF authentication

Values: "azure" "aws" "gcp" "oidc"
workload_identity_entra_resource string

e resource to use for WIF authentication on Azure environment