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.
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
sudo nano paths2. Enter Password3. Add in the path as follows for me:
control + x
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.
This should get your terminal back and running with gusto, or character(s). Happy CLI Querying!
Originally published at http://bigdatadave.com on July 28, 2020.