DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations

Trending

  • Transactional Outbox Patterns Step by Step With Spring and Kotlin
  • How To Use Pandas and Matplotlib To Perform EDA In Python
  • Chaining API Requests With API Gateway
  • Building a Flask Web Application With Docker: A Step-by-Step Guide

Trending

  • Transactional Outbox Patterns Step by Step With Spring and Kotlin
  • How To Use Pandas and Matplotlib To Perform EDA In Python
  • Chaining API Requests With API Gateway
  • Building a Flask Web Application With Docker: A Step-by-Step Guide
  1. DZone
  2. Data Engineering
  3. Databases
  4. Snowflake New Web Interface — Snowsight

Snowflake New Web Interface — Snowsight

Snowsight is open for all accounts running on Amazon Web Services and Microsoft Azure, while Google Cloud Platform is planned to be supported.

Istvan Szegedi user avatar by
Istvan Szegedi
·
Oct. 06, 20 · Analysis
Like (2)
Save
Tweet
Share
4.95K Views

Join the DZone community and get the full member experience.

Join For Free

Introduction

Snowflake has recently introduced a new, desktop-quality web user interface for ad-hoc data analysis and verification that supports fast querying, SQL auto-completion, automatic stats, and various charts for data visualization. The application is still in preview mode, meaning the account admins need to click on the Preview App menu and enable Snowsight. As of writing the article, Snowsight is open for all accounts running on Amazon Web Services and Microsoft Azure, while Google Cloud Platform is planned to be supported.

tool bar


Using Snowsight

According to Snowflake, the main use cases for Snowsight are data validation, explorative SQL queries, and "quick charts" to share with team members, while the classic BI tools  such as Tableau, Qlik, or Power BI are more geared towards corporate reporting needs, business users and complex dashboards

Figure 1: When to use Snowsight (Source: Snowsight Academy)  

SQL Auto-Completion

One of the most attractive features of Snowsight compared to the classic Worksheet is that it supports context-sensitive auto-completion.

For instance,  if you are typing a SELECT statement and start entering curr, Snowsight will recommend matching SQL functions that can be used in that place. 

current role

Figure 2: Auto-completion with SQL functions

Or, in the FROM section of the SQL statement, you can choose the names of the available tables offered by auto-completion:

salesforce

Figure 3: Auto-completion with table names


Automatic Statistics

When the SQL queries are executed, the Results section contains the data retrieved by the query and in addition to that, Snowsight will also provide statistics such as how many rows have been retuned, how long running the query took, how well the columns in the table are populated, etc. This can help system admins or data analysts to quickly identify potential data quality issues.

automatic stats

Figure 4: Automatic statistics

Resizing or Suspending Virtual Warehouses

Another great feature is the ability to resize or suspend the virtual data warehouses from within Snowsight.

virtual warehouse

Figure 5: Resizing the virtual warehouse from context menu

Date Range Selection

Snowsigth also supports out-of-the-box date range filters to allow users to simplify date selection.

For instance, the following query will generate a filter with multiple options:

select * from TPCH_SF001.ORDERS where O_ORDERDATE = :daterange

The date range filter will let data analysts pick update ranges like Lasy Day, Last 7 Days, Last 28 Days, Last 3 Months, Last 6 Monts, Last 12 Months, All Time, and Custom.

date ranges

Figure 6: Date Range Filters

In addition, Account Admins can grant permission for users to create their own custom filters  and use them in their subsequent queries.

Charts for Data Visualization

Snowsight supports various charts (line chart, bar chart, scatterplot, etc) to visualoze data.

Below is an example line chart with order data (X-axis displays dates bucketed by weeks, whereas Y-axis displays the order total price)

snowsight

Figure 7: Line chart in Snowsight

Sharing Your Work With Colleagues

Snowsight enables users to send colleagues links to view worksheets, folders, and dashboards that they own:

share

Figure 8: Sharing in Snowsight

Conclusion

Snowsight has become part of Snowflake's web user interface as a result of  Snowflake's acquisition of Numeracy. It provides a unique user experience with SQL auto-completion, visual charts, and sharing worksheets and dashboards thus offers a great tool to boost the productivity of the data analyst teams.

Amazon Web Services Database sql Web Service Data visualization Interface (computing) Chart

Opinions expressed by DZone contributors are their own.

Trending

  • Transactional Outbox Patterns Step by Step With Spring and Kotlin
  • How To Use Pandas and Matplotlib To Perform EDA In Python
  • Chaining API Requests With API Gateway
  • Building a Flask Web Application With Docker: A Step-by-Step Guide

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com

Let's be friends: