Snowflake: How Snowsight Is Better Than The Classic UI

Photo by Kelly Sikkema

Snowflake Snowsight offers an improved user experience in terms of writing and executing SQL queries. I’m going to share with you some of the things I like about Snowsight which might persuade you to move into it and leave the Classic UI behind.

Going into Snowsight

To get into Snowsight from the Classic UI, you just have to click the “Preview App” button on the menu bar beside other options like History, Worksheet, etc..

This will take you to Snowsight logon screen where it’s going to open a new Snowflake session upon logon.

File Directory-like Worksheets

Upon successful logon, you will be taken into the Worksheets tab. In Snowsight, your Worksheets are listed and organised as files as oppose to tabs in the Classic UI.

Snowsight

Classic UI

Code Assist

Writing queries in Snowsight is so much easier. As soon as you type something, a pop-up card will appear which will show matching codes based on what you’ve typed.

This means that in Snowsight, you don’t have to type everything. Just choose one of the options from the pop-up and hit Tab to autocomplete it.

This is also applicable even for Object Names. Notice that it also shows the row count of the matching table names.

Highlighted Error

In Snowsight, you can instantly find where the error is in your query, as it will not only give you the line number, but it will also highlight the code that is causing the error in your query.

This is extremely helpful especially when troubleshooting hundred-liner and/or unformatted queries.

Format Query

Speaking of unformatted queries, you now don’t have to use an external tool to perform a very simple job. Snowsight can format queries simply by clicking on your Worksheet Name and then “Format query”.

Below is the result of formatting the above one-liner query.

Filter Result set

Snowsight allows filtering of query results by using the Search Bar on top of the results pane.

Do not confuse this with the WHERE clause, the search is not tied to any column of the result, the search will be done for the entire row.

Result filtering is done automatically and instantly as you type. It will also provide some statistics based on the result of the query and your search. As in the example above, it shows that 195 out of 1,500 result rows are matched with my search.

Data Visualization

Since Snowsight is designed to support data analyst activities, it automatically generates charts from the query result which will enable us to instantly visualise our data. To view it, just click on the “Chart” button.

The chart display can be customised according to your preference. You can choose a different chart type, add more dimension, change the appearance, etc. all can be done on the right hand pane of the chart.

Share your Worksheet

Snowflake allows you to share your entire worksheet with the queries including the results if there’s any.

By clicking the “Share” button on the top right hand of the worksheet, a pop-up window will appear where you can add users whom you want to give access to your worksheet. These users must be an existing user within the same Snowflake Account. You can also set the access privilege of the users to share your worksheet with.

Wrap up

This blog does not do justice for Snowsight as we’ve covered only the improvements in Worksheets. There are other incredible features here which I’m sure you will find useful too, like the Dashboards and the Role Hierarchy Viewer. I will leave them for you to explore on your own.

Just like every new thing, it will take some time to adjust to the new UI but it is definitely something worth considering as it surely provides a better user experience than the Classic UI.

Please consider giving me a follow if you wish get more updates on Snowflake features. Thank you!

--

--

--

Snowflake Data Superhero | SnowPro Core Certified | Teradata 14 Certified Technical Specialist

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Design Tools for Monday 🧰

Ironhack’s Prework: Mauricio Carrasco_Challenge1

3 Reimagined Ways I Wish Twitter’s Bookmarks Could Work (and Look!)

[Payment proof]Facebook Research App- $5 Every Month + $10/Refer(per month)

Everything you need to know about Material Design 3

Who are my customers?

Task Analysis Research Methodology

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Clark Perucho

Clark Perucho

Snowflake Data Superhero | SnowPro Core Certified | Teradata 14 Certified Technical Specialist

More from Medium

Data Integration, Fivetran, and HVR at Powell Industries with Ajay Bidani

How to manage row level security in Snowflake?

Snowflake : To fetch all users and their associated roles without using ACCOUNTADMIN privileges in…

Snowflake Data Clean Rooms: The Problem with …Yao’s Millionaires’ Problem