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

INSTALL SnowSQL CLI

Download Links for windows , take latest one :

https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/1.2/windows_x86_64/index.html

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