#049: How to use SnowSQL | Install, Config & Query
Aug 09, 2023Most of the time we use Snowflake in the web UI.
But sometimes you just can't avoid the command line.
Whether for security reasons, automation or to handle large file uploads...
SnowSQL is an advanced feature of Snowflake that will open up a lot of options for you.
Plus it will make you look like a pro.
In today’s video you’ll see how to easily get up and running with this tool in under 10 minutes.
But first, what exactly is SnowSQL?
SnowSQL is the command line client for connecting to Snowflake.
You can execute SQL queries and perform all DDL and DML operations.
This also includes loading data into and unloading data out of database tables.
By the end of this video you’ll see be ready to use it on your own!
What will you learn?
- How to download & Install SnowSQL
- How to setup your local config file
- How to run basic SQL commands via the command line
Looking for more? Here are 2 other ways I can help you:
1. Simple Stack Academy: Join 100+ students in an end-to-end, project-based training. Simple Stack Academy teaches you a 5-Step Framework to design, build & automate reliable end-to-end data architectures using modern tools like dbt & Github. Ideal for both data engineers looking to advance their careers and data team leaders looking for a clear strategy to follow.
2. Consulting Services: Get personalized support to properly implement a well-structured, scalable, and maintainable data architecture at your company. Whether starting from scratch or migrating a legacy design, you'll get custom support each step of the way to make sure it's done right.