Snowflake: Command Not Found: SnowSQL

Posted by

You have installed SnowSQL on your shiney MacBook and for some reason when you go to CLI like a boss you get a “command not found: snowsql” error. This will really put a wrinkle in your day of SQL coding as I love SnowSQL for the ChUI and the autocomplete.

The Fix
In order to fix this you will need to dust off your terminal skills with nano. All the code is in this snippet, but I will also show the walkthrough for comfort.

1. Open Terminal
cd ..
cd ..
ls
cd etc
sudo nano paths
2. Enter Password
3. Add in the path as follows for me:
   /Applications/SnowSQL.app/Contents/MacOS/
control + x
Y
[ENTER]

Step 1: Open the Terminal and Cd to the Root and back into /etc/.

Step 2: Open Nano to Edit paths as Admin and enter password.

Step 3: Put in your path and close and save. Edit very carefully and use Control + X to close, Y and ENTER to save.
Pro Tip: To find your path open SnowSQL from Launchpad and it will be at the top of the terminal window.

Conclusion
This should get your terminal back and running with gusto, or character(s). Happy Querying!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s