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.
Step 4: Be sure to close the terminal window and reopen to apply the new changes as they apply at application startup.
Conclusion
This should get your terminal back and running with gusto, or character(s). Happy CLI Querying!
Big Data Dave 