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
| Feature | Description | How to Access |
|---|---|---|
| Worksheets | Write and run SQL queries interactively | Click 'Worksheets' tab in Snowsight UI |
| Dashboards | Create visual reports and charts | Click 'Dashboards' tab and add widgets |
| History | View past queries and performance details | Click 'History' tab |
| Data Browser | Explore databases, schemas, and tables visually | Use 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.
