Skip to Content
Snowflake: The Definitive Guide
book

Snowflake: The Definitive Guide

by Joyce Kay Avila
August 2022
Intermediate to advanced
465 pages
12h 20m
English
O'Reilly Media, Inc.
Content preview from Snowflake: The Definitive Guide

Chapter 11. Visualizing Data in Snowsight

Data visualization makes it much easier to identify trends, patterns, and outliers and to discover insights within complex data. Information displayed in a visual context, such as a graph or a map, is a more natural way for the human mind to comprehend large amounts of data. Business intelligence (BI) tools such as Domo, Power BI, Sisense, Sigma, Tableau, and ThoughtSpot are used in this way for corporate reporting and for building complex dashboards in which many users are consumers of a particular dashboard.

Sometimes individuals or small groups of users in an organization simply need to undertake ad hoc data analysis, perform data validation while loading data, or quickly create minor charts and dashboards that can be shared and explored together as a team. For those use cases, Snowflake’s Snowsight visualization tools are great choices. Snowsight visualization tools include automatic statistics with interactive results and dashboards with chart tiles.

Before we dive into Snowsight’s visualization tools, we need to discuss sampling. This is a consideration because we often deal with data sets that are too large for Snowsight statistics and visualizations to manage. Snowsight is especially useful in helping to identify outliers and quality issues with initial data loads, but its capabilities are intended for use on only a small number of rows. We can reduce a large data set into a smaller subset through the LIMIT clause or the SAMPLE ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Snowflake Data Engineering

Snowflake Data Engineering

Maja Ferle
Prompt Engineering for LLMs

Prompt Engineering for LLMs

John Berryman, Albert Ziegler

Publisher Resources

ISBN: 9781098103811Errata Page