snowsql
SnowSQL command-line client for Snowflake's Data Cloud. More information: https://docs.snowflake.com/en/user-guide/snowsql.html.
-
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}}
License and Disclaimer
The content on this page is copyright © 2014—present the tldr-pages team and contributors.This page is used with permission under Creative Commons Attribution 4.0 International License.
While we do attempt to make sure content is accurate, there isn't a warranty of any kind.