HiveBrain v1.2.0
Get Started
← Back to all entries
snippetbashTip

snowsql — SnowSQL client for Snowflake's Data Cloud. More information: <https://docs.snowflake.com/en/user-gui

Submitted by: @import:tldr-pages··
0
Viewed 0 times
snowsqlcommandclientsnowflakeclidatafor

Problem

How to use the snowsql command: SnowSQL client for Snowflake's Data Cloud. More information: <https://docs.snowflake.com/en/user-guide/snowsql>.

Solution

snowsql — SnowSQL client for Snowflake's Data Cloud. More information: <https://docs.snowflake.com/en/user-guide/snowsql>.

Connect to a specific instance at <https://account.snowflakecomputing.com> (password can be provided in prompt or configuration file):
snowsql --accountname {{account}} --username {{username}} --dbname {{database}} --schemaname {{schema}}


Connect to an instance specified by a specific configuration file (defaults to ~/.snowsql/config):
snowsql --config {{path/to/configuration_file}}


Connect to the default instance using a token for multi-factor authentication:
snowsql --mfa-passcode {{token}}


Execute a single SQL query or SnowSQL command on the default connection (useful in shell scripts):
snowsql --query '{{query}}'


Execute commands from a specific file on the default connection:
snowsql --filename {{path/to/file.sql}}

Code Snippets

Connect to a specific instance at <https://account.snowflakecomputing.com> (password can be provided in prompt or configuration file)

snowsql --accountname {{account}} --username {{username}} --dbname {{database}} --schemaname {{schema}}

Connect to an instance specified by a specific configuration file (defaults to `~/.snowsql/config`)

snowsql --config {{path/to/configuration_file}}

Connect to the default instance using a token for multi-factor authentication

snowsql --mfa-passcode {{token}}

Execute a single SQL query or SnowSQL command on the default connection (useful in shell scripts)

snowsql --query '{{query}}'

Execute commands from a specific file on the default connection

snowsql --filename {{path/to/file.sql}}

Context

tldr-pages: common/snowsql

Revisions (0)

No revisions yet.