Snowsql Setup | How to login to snowsql | snowsql CLI

Summary

In this tutorial, Rin Kumar B walks viewers through the process of setting up and using SnowSQL, the command-line interface for Snowflake. The video covers the installation of SnowSQL, configuring login credentials, and demonstrates how to log in using the CLI. Rin explains how to retrieve account names and usernames from Snowflake, providing step-by-step commands for interacting with databases, schemas, and tables. The tutorial is designed to help users easily navigate SnowSQL, offering them an alternative to the Snowflake UI and Classic Console for seamless data interaction.

Takeaways

• 😀 SnowSQL is a command-line interface (CLI) tool used to interact with Snowflake, providing an alternative to the Snowflake web interface.
• 😀 Before using SnowSQL, users need to install it. This involves downloading the appropriate version for your operating system (Windows, macOS, or Linux).
• 😀 To install SnowSQL on Windows, search for the SnowSQL download, click on the appropriate version for Windows, and follow the installation steps.
• 😀 During installation, SnowSQL can be set up with default settings, requiring no additional configuration unless administrative permissions are needed.
• 😀 After installation, users can access SnowSQL via the command prompt by entering the syntax: `snowSQL -a <account_name> -u <username>`.
• 😀 To get your Snowflake account name, navigate to the Snowflake UI, click on your account name, and copy the account URL. Trim the unnecessary parts to extract the correct account name.
• 😀 Your SnowSQL username can be obtained by running the `SELECT current_user;` query in Snowflake, which will return your Snowflake username.
• 😀 The password for SnowSQL is the same as the password used for logging into the Snowflake UI (Classic Console or Snowflake UI). Ensure the password is case-sensitive.
• 😀 Once logged in, you can execute commands to interact with your Snowflake environment, such as using the `USE DATABASE` command to switch databases and `SHOW TABLES` to view tables.
• 😀 It's important to remember that SnowSQL commands are case-sensitive, so be cautious when typing commands and passwords.
• 😀 The video concludes by encouraging viewers to subscribe and share the content if they found it helpful.

Q & A

What is SnowSQL?

SnowSQL is a command-line interface (CLI) tool used for interacting with Snowflake, which allows users to execute SQL queries and manage Snowflake accounts from the command line.

What are the two primary ways to log into Snowflake?

The two primary ways to log into Snowflake are through the Snowflake UI (User Interface) via the classic console and through SnowSQL, the command-line interface.

What is required to set up SnowSQL?

To set up SnowSQL, you need to download and install the SnowSQL CLI, configure your account and username, and provide the correct login credentials, including your password from the Snowflake UI.

How do you download SnowSQL for a Windows machine?

To download SnowSQL for Windows, visit the SnowSQL download page, find the Windows version, and click to download. After downloading, you can run the installer and follow the on-screen instructions.

What is the syntax for logging into SnowSQL?

The syntax for logging into SnowSQL is: 'snowSQL -a <account_name> -u <username>' followed by the password from the Snowflake UI.

How do you find your Snowflake account name for SnowSQL?

To find your Snowflake account name, log into the Snowflake UI, navigate to your account settings, click on 'Account,' and then copy the account URL. Extract the account name from the URL by removing parts like 'snowflakecomputing.com'.

How do you find your username for logging into SnowSQL?

To find your username for SnowSQL, use the SQL command 'SELECT CURRENT_USER;' in the Snowflake UI or CLI to get the current user logged in.

What is the significance of the password when logging into SnowSQL?

The password used for logging into SnowSQL is the same password you set for your Snowflake UI (classic console). It is case-sensitive and not visible when typing in the CLI.

How do you access and use a specific database and schema in SnowSQL?

To access a specific database and schema in SnowSQL, use the 'USE DATABASE <database_name>' and 'USE SCHEMA <schema_name>' commands, replacing the placeholders with the actual names.

Can SnowSQL be used for actions other than logging in?

Yes, SnowSQL can be used to execute SQL queries, display tables with 'SHOW TABLES,' and manage databases, schemas, and other Snowflake objects directly from the command line.