Skip to content

lab2.dev is launched! Build python web apps with plain English, no code required.

What is Snowsight: The New Face of Snowflake Data Visualization

Antonio Di Nicola
Name
Antonio Di Nicola

Updated on

Snowflake, the cloud-based data warehousing platform, is making a significant shift in its user interface. The company is transitioning from its Classic Console to a more modern, intuitive, and feature-rich interface known as Snowsight. This transition is not just a cosmetic change; it's a strategic move that enhances the user experience and optimizes data management tasks.

In this comprehensive guide, we will delve into the world of Snowsight, exploring its features, benefits, and how it compares to the Classic Console. We will also provide practical tips on how to use Snowsight effectively, whether you're a beginner or an experienced user. So, let's embark on this journey to master Snowsight and unlock its full potential in data management.

What is Snowsight?

Snowsight is a modern, intuitive, and interactive web-based interface designed to enhance the user experience in data exploration, visualization, and reporting. It is a part of the Snowflake Data Cloud platform, a leading cloud-based data warehousing solution. Snowsight provides users with the ability to write SQL queries, visualize the results, and share them with others, all within the same platform. It offers a wide range of features including auto-complete suggestions, syntax highlighting, and error messaging, making it an ideal tool for both novice and experienced SQL users.

In addition to its SQL editor, Snowsight also offers advanced data visualization capabilities. Users can create a variety of charts and graphs directly from their query results, allowing for a more in-depth analysis of data. These visualizations can be customized and saved for future reference, facilitating collaboration and decision-making processes. Furthermore, Snowsight provides real-time performance insights, enabling users to optimize their queries and improve overall efficiency. With its user-friendly interface and powerful features, Snowsight significantly enhances the data exploration and visualization experience in the Snowflake environment.

How to Use Snowsight in Snowflake

Snowsight is more than just a new look for Snowflake; it's a powerful tool that simplifies data management and enhances productivity. The Snowsight interface is designed to be user-friendly, making it easy for beginners to navigate and use. Here's a simple guide to get you started:

  1. Logging in: To access Snowsight, log into your Snowflake account. The new interface is now the default, so you don't need to switch from the Classic Console.

  2. Navigating the Interface: The Snowsight interface is intuitive and easy to navigate. Key features such as data monitoring, query performance optimization, and data visualization are readily accessible.

  3. Using IntelliSense and Auto-Complete: Unlike the Classic Console, Snowsight comes with IntelliSense and auto-complete capabilities. This feature saves time and helps you get to your results faster.

  4. Visualizing Data: Snowsight provides data profiling and ad-hoc dashboards for slicing and dicing your data for on-the-fly analysis. This feature allows you to quickly visualize results and prototype dashboards.

How to Visualize Snowflake Data

Snowsight allows you to visualize snowflake data within the existing plan, but what if you want more advanced data visualization features? For example, do you want to explore the data insights with one click, conduct causal analysis, or explore the patterns or anomalies from complicated data?

RATH is the solution that will impress you. RATH (opens in a new tab) is an Open Source Data Analysis and Visualisation tool that can streamline your Snowflake data workflow.

Here is how you can get data insights with one click:


Causal discovery is a critical part of the data analysis process. RATH has included the Causal Discovery feature that is ready for everyone.


Discovering the underlying patterns and trends from a complicated data source can be extremely challenging. The Data Painter feature is designed to fix this problem. You can easily clean data, model data, and explore data using a Painting Tool, which turns the complex Exploratory Data Analysis process visual and simple.

The following demo video shows the process of finding out the meaning of the trend within a certain data set:


RATH supports a wide range of data sources that does not disturb your existing workflow. Here are some of the major database solutions that you can connect to RATH:

Supported Database by RATH

Interested? You can try RATH right now for its full feature at the RATH website (opens in a new tab). You can also visit RATH GitHub (opens in a new tab) for its source code.

Snowsight/RATH for Snowflake Data Visuzliation (opens in a new tab)

Data Governance in Snowsight

Data governance is a critical aspect of data management. It involves the processes and policies that ensure data integrity, security, and availability. Snowsight provides several features that support effective data governance:

  1. Monitor Costs: With Snowsight, you can visualize credit consumption across your organization, your virtual warehouse’s engines, and queries. This feature helps you manage your spending and cap usage.

  2. Access Data: Using the Snowflake marketplace, you can access hundreds of data listings. With the standard listings, you can try them in an instant.

  3. Speed Up Data Preparation and Analysis: Snowsight’s powerful search capabilities allow you to locate objects by simply searching for keywords. This feature speeds up data preparation and analysis.

  4. Explore Roles and Users: In the roles menu, you can visualize role relationships, view role details for a specific user, drill down into specific privileges, and analyze/audit your access control.

Snowsight vs. Classic Console

The transition from the Classic Console to Snowsight is a significant upgrade that offers numerous benefits. Here's a comparison of the two interfaces:

  1. User Interface: Snowsight offers a modern, intuitive, and user-friendly interface compared to the Classic Console. It's designed to enhance the user experience and make data management tasks easier and more efficient.

  2. Features: Snowsight comes with several new features that were not available in the Classic Console. These include IntelliSense and auto-complete capabilities, real-time data monitoring, and powerful search capabilities. These features save time and enhance productivity.

  3. Data Visualization: Unlike the Classic Console, Snowsight provides data profiling and ad-hoc dashboards for on-the-fly analysis. This feature allows users to quickly visualize results, prototype dashboards, and share insights with their team.

  4. Data Governance: Snowsight offers robust data governance features, including cost monitoring, data access, and role exploration. These features help ensure data integrity, security, and availability.

Snowsight Usage for Dashboards

Creating dashboards is a critical aspect of data management and analysis. Dashboards provide a visual representation of data, making it easier to understand and interpret. With Snowsight, building dashboards is a breeze. Here's how you can do it:

  1. Accessing the Dashboard Feature: On the Snowsight interface, you'll find the dashboard feature readily accessible. This feature allows you to create custom dashboards based on your data analysis needs.

  2. Creating a Dashboard: To create a dashboard, simply select the data you want to visualize and choose the type of visualization you prefer. Snowsight supports various types of visualizations, including charts, graphs, and tables.

  3. Customizing Your Dashboard: Snowsight allows you to customize your dashboard to suit your needs. You can add, remove, or rearrange data elements, change the color scheme, and adjust the layout to create a dashboard that's truly yours.

  4. Sharing Your Dashboard: Once you're satisfied with your dashboard, you can easily share it with your team. Snowsight provides options for sharing dashboards via email, social media, or direct link.

Improving Productivity with Snowsight

Snowsight is not just about data management; it's also about enhancing productivity. Here are some tips and tricks to increase your productivity using Snowsight:

  1. Leverage IntelliSense and Auto-Complete: These features can save you time by suggesting relevant keywords and completing your sentences as you type.

  2. Use the Search Feature: Snowsight's powerful search capabilities allow you to quickly locate objects, saving you the time and effort of manually searching for them.

  3. Take Advantage of the Dashboard Feature: Dashboards allow you to visualize data, making it easier to understand and interpret. This can speed up your data analysis process and help you make informed decisions faster.

  4. Utilize the Support Menu: Within Snowsight, you can leverage the support menu to manage all external engagements with Snowflake support. This can save you time and ensure that you get the help you need when you need it.

#Snowsight Usage for Dashboards

Creating dashboards is a critical aspect of data management and analysis. Dashboards provide a visual representation of data, making it easier to understand and interpret. With Snowsight, building dashboards is a breeze. Here's how you can do it:

  1. Accessing the Dashboard Feature: On the Snowsight interface, you'll find the dashboard feature readily accessible. This feature allows you to create custom dashboards based on your data analysis needs.

  2. Creating a Dashboard: To create a dashboard, simply select the data you want to visualize and choose the type of visualization you prefer. Snowsight supports various types of visualizations, including charts, graphs, and tables.

  3. Customizing Your Dashboard: Snowsight allows you to customize your dashboard to suit your needs. You can add, remove, or rearrange data elements, change the color scheme, and adjust the layout to create a dashboard that's truly yours.

  4. Sharing Your Dashboard: Once you're satisfied with your dashboard, you can easily share it with your team. Snowsight provides options for sharing dashboards via email, social media, or direct link.

Improving Productivity with Snowsight

Snowsight is not just about data management; it's also about enhancing productivity. Here are some tips and tricks to increase your productivity using Snowsight:

  1. Leverage IntelliSense and Auto-Complete: These features can save you time by suggesting relevant keywords and completing your sentences as you type.

  2. Use the Search Feature: Snowsight's powerful search capabilities allow you to quickly locate objects, saving you the time and effort of manually searching for them.

  3. Take Advantage of the Dashboard Feature: Dashboards allow you to visualize data, making it easier to understand and interpret. This can speed up your data analysis process and help you make informed decisions faster.

  4. Utilize the Support Menu: Within Snowsight, you can leverage the support menu to manage all external engagements with Snowflake support. This can save you time and ensure that you get the help you need when you need it.

Conclusion

Snowsight is a game-changer in the world of data management. It offers a modern, intuitive, and feature-rich interface that enhances the user experience and optimizes data management tasks. Whether you're a beginner or an experienced user, Snowsight offers a range of features and benefits that can revolutionize your data analytics experience. So, why wait? Make the switch to Snowsight today and unlock its full potential in data management.

FAQ

  1. What is Snowsight?

Snowsight is a web interface for Snowflake, a cloud-based data warehousing solution.

  1. What is Snowsight vs Snowflake?

Snowsight is a web interface designed to support data analyst activities, while Snowflake is a cloud-based data warehousing solution.

  1. What is Snowsight used for?

Snowsight is used to perform critical Snowflake operations, improve productivity, and create ad-hoc dashboards for on-the-fly analysis.

  1. What is the URL for Snowsight?

Snowsight is accessible through the Snowflake web interface, which can be accessed by Snowflake account holders.

  1. Is Snowsight free?

The pricing for Snowflake and its features, including Snowsight, varies depending on usage and requirements. Please refer to Snowflake's official documentation or contact their sales team for more details.