Install and use Basic Snowsql CLI commands

Mar 14, 2020

Before starting, i wanted to share for windows user how to install the SnowSQL :

INSTALL SnowSQL CLI

Download Links for windows , take latest one :

to customize the usage , you can open file browser and paste this :

_{%USERPROFILE%\.snowsql\}

Step 1 : start your command line ( cmd ) and type snowsql

Step 2 : connect to your snowflake account

Connect with login & password : type
- snowsql -a XXX.eu-central-1
Connect through Okta ( SSO ) :
- snowsql --authenticator https://logon.okta.com/ -a XXX.eu-central-1
Connect to specific Schema/DB/Warehouse through Okta :
- snowsql --authenticator https://logon.okta.com/ -a XXXX.eu-central-1 -d DATABASE -s SCHEMA -w WAREHOUSE -r ROLE

RUN Snowflake SQL queries in command-line

snowsql --authenticator https://logon.okta.com/ -a XXXX.eu-central-1 -d DATABASE -s SCHEMA -w WAREHOUSE -r ROLE -f file.sql

Exit command line : ctrl +d

Author & blogger on the latest data analytics technologies: Hadoop, Snowflake, Cloud ( AWS ), ETL .. etc

Oct 2, 2020 Amine Hallam

Sep 14, 2020 Amine Hallam

Aug 15, 2020 Amine Hallam

Data Engineering