Bird
Raised Fist0
SnowflakeHow-ToBeginner · 4 min read

How to Use Snowsight in Snowflake: Quick Guide

Use Snowsight by logging into the Snowflake web interface and selecting the Snowsight UI for interactive data exploration, query writing, and dashboard creation. It provides visual tools like worksheets, dashboards, and history to manage and analyze your Snowflake data easily.
📐

Syntax

Snowsight is accessed through the Snowflake web interface and does not require code syntax but uses UI elements and SQL queries. Key parts include:

  • Worksheets: Write and run SQL queries interactively.
  • Dashboards: Create visual reports from query results.
  • History: View past queries and their performance.
  • Data Browser: Explore databases, schemas, and tables visually.
sql
SELECT * FROM my_database.my_schema.my_table LIMIT 10;
💻

Example

This example shows how to run a simple query in Snowsight and create a dashboard widget from the results.

sql
SELECT category, COUNT(*) AS total_sales
FROM sales_data
GROUP BY category
ORDER BY total_sales DESC
LIMIT 5;
Output
CATEGORY | TOTAL_SALES ------------|------------ Electronics | 1500 Clothing | 1200 Books | 900 Toys | 600 Groceries | 450
⚠️

Common Pitfalls

Common mistakes when using Snowsight include:

  • Trying to use classic Snowflake UI features that are not available in Snowsight.
  • Not saving worksheets or dashboards, leading to lost work.
  • Running very large queries without limits, causing slow response.
  • Ignoring role permissions that restrict access to data or UI features.

Always check your role permissions and save your work frequently.

sql
/* Wrong: Running a query without LIMIT on large table */
SELECT * FROM sales_data;

/* Right: Use LIMIT to avoid slow loading */
SELECT * FROM sales_data LIMIT 100;
📊

Quick Reference

FeatureDescriptionHow to Access
WorksheetsWrite and run SQL queries interactivelyClick 'Worksheets' tab in Snowsight UI
DashboardsCreate visual reports and chartsClick 'Dashboards' tab and add widgets
HistoryView past queries and performance detailsClick 'History' tab
Data BrowserExplore databases, schemas, and tables visuallyUse the left sidebar navigation
✅

Key Takeaways

Snowsight is Snowflake's modern web UI for interactive data analysis and visualization.
Use worksheets to write SQL queries and dashboards to create visual reports.
Always save your worksheets and dashboards to avoid losing work.
Limit query results during exploration to improve performance.
Check your Snowflake role permissions to access Snowsight features properly.