SETUP SNOWSQL ON MAC
SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables.
You will need to have a profile configured on your Terminal with Homebrew package manager installed on your machine.
I have Anaconda setup on my Mac to manage environment variables, you do not need it for this but is considered best practice to organize packages and libraries for different types of environments depending on your use case.
List your current env variables in Anaconda:
Terminal Command:
% conda env list
Examples:
- base
- snowflake
- webdev
Installing SnowSQL
There are a few ways to install the SnowSQL — CLI client, in this case we will be using the Homebrew Cask MacOS configuration method for ZSH (Z Shell)
Terminal Command:
brew install --cask snowflake-snowsql
- Other methods can be found here: https://docs.snowflake.com/en/user-guide/snowsql-install-config
Note: The SnowSQL installer installs the executable in /Applications/SnowSQL.app/Contents/MacOS/snowsql and appends this path to the PATH or alias entry in ~/.profile.
