Snowflake: How Snowsight Is Better Than The Classic UI

Clark Perucho
4 min readAug 15, 2021
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…

Clark Perucho

Snowflake Data Superhero | Certified SnowPro: Administrator | Teradata 14 Certified Technical Specialist