If you’re interested in using these parameters or want more information check out the docs.Muon SSH Terminal/SFTP client ( Formerly Snowflake )Įasy and fun way to work with remote servers over SSH.
You can (and should) use the config file so you don’t need to type it all out. Snowsql -a **.east-us-2.azure -u lmunro -d SNOWFLAKE_SAMPLE_DATA -s TPCDS_SF100TCL -w LUCASMUNRO_WHĭon’t worry if that’s a bit overwhelming. In fact, you can login and set up your environment all in one line, like this: Yes! There are a bunch of parameters which can make your life easier. Are there any other parameters that I should know about? It then uses those credentials and other configurations to quickly log you in and set up your environment. The -c parameter tells the program snowsql to look in ~/.snowsql/config for a connection named lmunro_config. Whenever you run a program in the terminal you can specify arguments with a dash (-). For more information check out the public documentation.
You can preset login credentials and database settings by adding a block and specify options by adding to the block. The config file in the SnowSQL folder is where you can set configuration and options for the CLI. It’s preferable to the UI if you already have a grasp of terminal operations and don’t require the UI to navigate around. SnowSQL CLI is a quick way to plug into Snowflake directly from the terminal. # auto_completion gives you possible existing options, very helpful! To auto change the prompt format, add the following to the configuration file. This prompt can be a bit lengthy but you can edit the prompt with the following command: The tokens can be seen in the image above. SnowSQl prompt automatically displays the current user, warehouse, database and schema. Open the file named config and add the following.You can edit the snowSQL config file to perform these automatically. However, it can be quite tedious to type in your account, username, password, warehouse, DB, and schema every time you login. Yours will be different unless you somehow stole my laptop in which case please give it back.)Īwesome! Now we’re ready to perform whatever data analytics you desire. (Note: Lukes-MacBook-Pro and lmunro are specific to my console. Good! Now that snowsql has been installed, let’s set up our environment to work.Īccount name can be found in the first part of your url when logged into snowflake (everything before, for instance sample_username.sample_region.azure)ĬREATE WAREHOUSE yourname_WH AUTO_SUSPEND = 60 AUTO_RESUME=TRUE
DOWNLOAD SNOWFLAKE PRO FREE DOWNLOAD
Click on bootstrap -> 1.2 (or newest version) -> Pick your OS (Darwin is Mac) -> Download the latest version.Click on Downloads -> Snowflake Repository.Login into Snowflake and click on help in the top right corner.
DOWNLOAD SNOWFLAKE PRO FREE INSTALL
Step 1 – Download and install SnowSQL CLI It’s an easy way to access snowflake right from your command line and has all the same capabilities as the Snowflake UI. It allows you to execute SQL queries and perform all DDL and DML operations. SnowSQL is the command line client for Snowflake.