A Beginner’s Guide to Snowsight in Snowflake

If you’re new to Snowflake, you’ve probably heard the term Snowsight thrown around and wondered; what exactly is it, and why should I care?

Don’t worry. In this beginner-friendly guide, I’ll walk you through what Snowsight is, why it exists, and how you can start using it to explore data in Snowflake, without feeling overwhelmed.

By the end, you’ll feel confident enough to log in, click around, and even run your first query.

Snowflake as a Library, Snowsight as the Reading Room

Here’s the simplest way to think about it:

• Snowflake is like a massive library filled with data.
• Snowsight is the modern reading room inside that library where you can sit, browse, search, take notes, and even create charts.

In other words, Snowsight is the interface that makes Snowflake approachable, even for beginners who are not SQL experts.

What is Snowsight?

Snowsight is Snowflake’s web-based user interface.

It’s where you:

• Write and run queries
• Browse through databases and tables
• Visualise query results as charts
• Build dashboards to share with your team
• Manage users, roles, and warehouses (if you’re an admin)

Before Snowsight, there was the Classic Console, which worked but wasn’t very friendly. Snowsight is its modern, polished replacement, designed to make your data work easier and more visual.

A Quick Tour of the Snowsight Interface

When you first log in, the Snowsight UI looks clean and intuitive. Here are the main sections you’ll use as a beginner:

1. Worksheets – Think of these as notebooks where you write and run SQL queries.

• Example: SELECT CURRENT_DATE; to check today’s date.
• Results appear instantly in a table, and you can even chart them.

2. Databases Explorer – On the left panel, you can click through your databases, schemas, and tables, just like navigating folders on your computer.

3. Query Results & Charts – Every time you run a query, you can quickly turn the results into a bar chart, line chart, or pie chart.

4. Dashboards – Combine multiple charts into a dashboard and share it with teammates.

5. History – See every query you’ve run before (or that others have, depending on permissions). Super useful for learning from past work.

6. Admin Tools – Manage warehouses, roles, and users if you have admin access.

Why Beginners Should Start with Snowsight

Get Amarachukwu Eze’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

If you’re a total newbie to Snowflake, Snowsight is your best friend. Here’s why:

• It’s visual: you don’t have to export to Excel just to make a chart.
• It’s safe: you won’t break your database just by exploring.
• It’s beginner-friendly: you don’t need advanced SQL to start.
• It’s collaborative: you can share worksheets and dashboards with others.

Basically, Snowsight lowers the barrier to entry. Instead of staring at lines of code, you can see and interact with your data.

Snowsight vs. Classic Console

If you’ve heard of the Classic Console, here’s how Snowsight improves on it:

Unless you’re using very old Snowflake documentation, you’ll almost always be working with Snowsight.

Getting Started with Snowsight

Here’s how you can try it right now:

1. Log in to your Snowflake account.
2. Make sure you’re in Snowsight (it’s usually the default now).
3. Open a new worksheet.
4. Run your first simple query:

SELECT CURRENT_DATE;

5. Try exploring a database and running:

SELECT * 
FROM MY_DATABASE.MY_SCHEMA.MY_TABLE
LIMIT 10;

6. Click the “Chart” option to turn your query results into a visualisation.

🎯 Boom! you’ve just started working with Snowflake through Snowsight!

Conclusion: Your First Step into Snowflake Made Easy

Snowsight is the easiest way to get comfortable with Snowflake. It’s the beginner’s control panel, the modern reading room for your data library.

If you’re just starting out:

• Don’t be afraid to click around.
• Start with simple queries.
• Play with the charts.
• Build a mini dashboard.

The more you experiment, the more natural it will feel.

✍️ Over to you: Have you tried Snowsight yet? What’s the first query you ran?