I did not know this was possible. Most of my dev work is split into writing Python code in VS Code and SQL in Snowflake’s Snowsight UI. Turns out you could connect to your Snowflake warehouse using a Snowflake Extension for VS Code.

Steps to get you there:

Fetch Account Details

Go to your Snowsight account, at the bottom left you should see an account indicator to get account information. Get the account URL from there

The URL should look like this:

https://<account-identifier>.snowflakecomputing.com

Copy the account-identifier.

Install Extension

Next, open VS Code and search for Snowflake in Extensions. Install it.

Add Account Information

Open the extension and add Account Info.

Click continue and pick a way to login. I prefer single-sign on to keep the sign-in process secure and free from storing passwords.

Use Extension!

Write your queries, save them, check history, play with the output tables, download into CSV, use CSV integration to edit results - endless possibilities.

Integrate git, make code repositories and make sure your whole team is on the same page with you with version controlling.

Life is great

It was great after I started using VS Code for all work in Jupyter Notebooks. It just got better!