snippetbashTip
snowsql — SnowSQL client for Snowflake's Data Cloud. More information: <https://docs.snowflake.com/en/user-gui
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.