geohernandez
Menu
  • HOME
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
  • English
    • English
    • Español
Menu

Getting Started with SnowSQL: Connecting to Your Snowflake Account

Posted on October 29, 2024November 4, 2024 by geohernandez

In this quick guide, we’ll walk through the essential steps to connect to Snowflake using SnowSQL, Snowflake’s powerful command-line interface. You’ll learn how to set up SnowSQL, configure your connection settings, and authenticate securely to your Snowflake account. Whether you’re new to Snowflake or just getting started with SnowSQL, this tutorial will provide a solid foundation to help you query and manage data in Snowflake directly from your terminal.

Read more: Getting Started with SnowSQL: Connecting to Your Snowflake Account

Contents

  • What is SnowSQL?
  • How to install SnowSQL?
  • Preparing the credentials and accessing SnowSQL
  • Conclusion

What is SnowSQL?

We can define it as the command line client connects to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables.

How to install SnowSQL?

The process of installing SnowSQL is simple, you have to go to the Snowflake link for downloading.

Download SnowSQL

You should choose the version which is required for you. In my case, I have the Windows version.

Once you have downloaded the SnowSQL installer, you should follow the next steps as the following images show

Preparing the credentials and accessing SnowSQL

If you are using Windows, you could use Powershell and Command Prompt . In my case, I will open Command Prompt and prepare the snowsql command.

1
snowsql -a account_name -u User -r SYSADMIN -w COMPUTE_WH

You can get the account name from your Snowflake UI, go to your account and copy account URL, once copied, you should remove the https:// and the text .snowflakecomputing.com . The User is who has been defined by you.

At this point, you will receive a Password prompt. Once you enter it, you should be able to access the main or default DB associated with your User.

So, here, you can interact with Snowflake, in my example I does a simple query, for instance:

SHOW TABLES;

Note: If you are working interactively into Windows CMD, you can set the password variable into your session and SnowSQL will automatically read it. To initialize the password you can simply write in command line the code:

1
set SNOWSQL_PWD=YourPasswordHere

Conclusion

In this guide, we covered the basic steps to connect to Snowflake using SnowSQL, from installation to secure authentication. With SnowSQL, you’re equipped to run SQL queries and manage data in Snowflake seamlessly from your terminal. This foundation will help you utilize Snowflake’s full potential for efficient data operations.

Category: Data Engineering, Snowflake

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search for articles

Recent Posts

  • Quick Guide: BigQuery Service Account Setup Using gcloud
  • The Art of Data Modeling in AI times
  • Getting Started with Snowflake’s Snowpipe for Data Ingestion on Azure

Categories

  • Airflow (1)
  • Azure (6)
  • Azure DevOps (2)
  • Bash script (1)
  • Blog (1)
  • Cassandra (3)
  • Chronicles from the trenches (26)
  • Data Architecture (3)
  • Data Engineering (11)
  • DB optimization (2)
  • Events (2)
  • GIT (1)
  • MySQL (1)
  • Python (7)
  • Snowflake (3)
  • SQL Saturday (1)
  • SSIS (2)
  • T-SQL (5)
  • Uncategorized (2)

Archives

  • May 2025 (1)
  • March 2025 (1)
  • January 2025 (2)
  • October 2024 (1)
  • July 2024 (1)
  • May 2024 (1)
  • December 2023 (1)
  • November 2023 (1)
  • August 2023 (1)
  • June 2023 (1)
  • December 2022 (1)
  • November 2022 (1)
  • July 2022 (1)
  • March 2022 (1)
  • September 2021 (1)
  • May 2021 (1)
  • March 2021 (1)
  • February 2021 (3)
  • December 2020 (1)
  • October 2020 (3)
  • September 2020 (1)
  • August 2020 (1)
  • January 2020 (1)
  • August 2019 (1)
  • July 2019 (1)
  • June 2019 (1)
  • May 2019 (1)
  • April 2019 (1)
  • March 2019 (1)
  • November 2018 (3)
  • October 2018 (1)
  • September 2018 (1)
  • August 2018 (2)
© 2025 geohernandez | Powered by Minimalist Blog WordPress Theme