Snowsight UI, Worksheets, Notebooks, and Snowflake Copilot: A Beginner's Guide

If you're new to Snowflake, you'll quickly discover that its web interface, Snowsight, is where most of your work happens. Unlike traditional databases where you might use a command-line tool or a separate IDE, Snowflake provides a rich, browser-based environment for querying, analyzing, and visualizing data. In this tutorial, we'll explore three core features: Worksheets, Notebooks, and Snowflake Copilot. Worksheets are your go-to for writing and running SQL queries. Notebooks offer a more flexible, cell-based environment where you can combine SQL, Python, and markdown. And Snowflake Copilot is an AI-powered assistant that helps you write queries, understand your data, and even debug errors. By the end of this guide, you'll be able to navigate Snowsight confidently, create and manage worksheets and notebooks, and leverage Copilot to boost your productivity. Whether you're a data analyst, engineer, or developer, these tools will streamline your workflow and help you get insights faster.

Getting Started with Snowsight

Snowsight is the modern web interface for Snowflake. To access it, log in to your Snowflake account. You'll be greeted by a navigation bar on the left with options like Worksheets, Notebooks, Data, and more. The main area is where you'll run queries and view results. Snowsight replaces the classic console and offers a more intuitive experience. It supports multiple worksheets, query history, and built-in charting. To get started, click on 'Worksheets' in the left panel. You'll see a list of your existing worksheets and a button to create a new one. Each worksheet is associated with a specific database, schema, and warehouse. You can set these using dropdowns at the top of the worksheet. The SQL editor supports syntax highlighting, autocomplete, and multiple tabs. Run a query by selecting the text and clicking the 'Run' button or pressing Ctrl+Enter. Results appear below in a table format. You can also export results to CSV or JSON.

-- Set context
USE DATABASE sales_db;
USE SCHEMA public;
USE WAREHOUSE my_wh;

-- Simple query
SELECT * FROM orders LIMIT 10;

Working with Worksheets

Worksheets are the bread and butter of Snowsight. They allow you to write and execute SQL queries, view results, and save your work. You can create multiple worksheets, organize them into folders, and share them with team members. Each worksheet has its own context, so you can have one worksheet for development and another for production. To create a new worksheet, click the '+' icon next to 'Worksheets' or use the 'New Worksheet' button. You can also duplicate existing worksheets. The editor supports multi-line queries, comments, and keyboard shortcuts. You can run a single statement or multiple statements at once. Results are displayed in a grid, and you can click on a row to see details. Worksheets also support parameterized queries using Snowflake's session variables. For example, you can define a variable and use it in your query. To save a worksheet, click the save icon or use Ctrl+S. Worksheets are automatically saved as you work, but it's good practice to explicitly save after changes.

-- Using session variables
SET @min_total = 100;

SELECT * FROM orders WHERE total > $min_total;

Introduction to Notebooks

Notebooks in Snowsight are similar to Jupyter notebooks but integrated with Snowflake. They allow you to combine SQL, Python, and markdown cells in a single document. This is great for data exploration, prototyping, and sharing analyses. To create a notebook, click on 'Notebooks' in the left panel and then 'New Notebook'. You'll see a blank notebook with a toolbar. You can add cells by clicking the '+' button. Each cell can be one of three types: SQL, Python, or Markdown. SQL cells run queries against Snowflake and display results. Python cells run Python code using Snowpark, which allows you to process data within Snowflake. Markdown cells are for documentation. Notebooks are executed cell by cell, and you can run all cells or a selection. Results from SQL cells appear as tables or charts. Python cells can output text, dataframes, or visualizations. Notebooks are saved automatically and can be shared with others. They are ideal for iterative analysis and collaboration.

-- SQL cell in a notebook
SELECT region, SUM(sales) as total_sales
FROM orders
JOIN customers ON orders.customer_id = customers.id
GROUP BY region;

Using Snowflake Copilot

Snowflake Copilot is an AI-powered assistant that helps you write SQL, understand your data, and debug queries. It appears as a chat panel in Snowsight. You can ask Copilot questions like 'Show me the top 10 customers by revenue' or 'Explain this query'. Copilot will generate SQL or provide explanations. To use Copilot, click on the Copilot icon (a small robot) in the top right corner of Snowsight. A chat panel opens. You can type natural language queries, and Copilot will respond with SQL code or text. You can also highlight a query in your worksheet and ask Copilot to explain or optimize it. Copilot is context-aware, meaning it knows your database schema and can suggest relevant columns. However, it's important to review Copilot's suggestions before running them, as they may not always be perfect. Copilot is especially useful for beginners who are learning SQL or for experienced users who want to speed up common tasks.

-- User asks: 'Find orders placed in the last 7 days'
-- Copilot generates:
SELECT *
FROM orders
WHERE order_date >= CURRENT_DATE - INTERVAL '7 days';

Best Practices for Snowsight

To get the most out of Snowsight, follow these best practices. First, organize your worksheets and notebooks into folders by project or environment. This makes it easy to find your work. Second, use descriptive names for your worksheets and notebooks. Instead of 'Untitled', use 'Monthly Sales Report' or 'Customer Segmentation Analysis'. Third, leverage the query history to review past queries and their performance. You can also clone queries from history. Fourth, use the built-in charting feature to visualize query results directly in the worksheet. This is great for quick data exploration. Fifth, set appropriate warehouse sizes for your queries. For large data sets, use a larger warehouse to speed up execution. For small queries, use a smaller warehouse to save credits. Sixth, use the 'Download Results' option to export data as CSV or JSON for external analysis. Finally, share worksheets and notebooks with your team using the 'Share' button. You can control permissions (view or edit).

-- Example: Using a small warehouse for quick checks
USE WAREHOUSE my_small_wh;

-- Example: Using a large warehouse for heavy queries
USE WAREHOUSE my_large_wh;
SELECT * FROM large_table WHERE condition;

Advanced Notebook Features

Notebooks offer advanced features for power users. You can schedule notebooks to run automatically using Snowflake tasks. This is useful for generating daily reports. To schedule a notebook, go to the notebook's settings and create a task. You can also parameterize notebooks using variables. For example, you can define a date range variable and use it in SQL cells. Notebooks support version history, so you can revert to previous versions. You can also export notebooks as HTML or PDF for sharing. Another advanced feature is the ability to use Python libraries like pandas, matplotlib, and seaborn within Python cells. This allows you to create sophisticated visualizations and data transformations. However, note that Python cells run on Snowflake's infrastructure, so you have access to Snowpark's capabilities. You can also use SQL cells to create temporary tables that are then used in Python cells. This hybrid approach is powerful for complex analyses.

# Python cell in a notebook
import pandas as pd
import matplotlib.pyplot as plt

# Assuming a SQL cell created a temp table 'sales_summary'
session.sql("SELECT * FROM sales_summary").collect()
df = session.table("sales_summary").to_pandas()

# Plot
plt.figure(figsize=(10,6))
plt.bar(df['REGION'], df['TOTAL_SALES'])
plt.title('Sales by Region')
plt.show()

Troubleshooting Common Issues

Even with a smooth interface, you may encounter issues. Here are common problems and solutions. If a worksheet fails to load, try clearing your browser cache or using incognito mode. Sometimes browser extensions interfere. If a query times out, check your warehouse size. A small warehouse may be insufficient for large queries. Consider using a larger warehouse or optimizing the query. If you see 'Object does not exist' errors, verify the database and schema context. Also check that you have the necessary privileges. If Copilot is not responding, ensure it's enabled in your account settings. Some organizations disable Copilot for security reasons. If a notebook cell hangs, check if the warehouse is running. You can also try restarting the notebook. For persistent issues, check the Snowflake status page or contact support. Remember to use the 'Query History' to see error details.

-- Check current context
SELECT CURRENT_DATABASE(), CURRENT_SCHEMA(), CURRENT_WAREHOUSE();

-- Check warehouse status
SHOW WAREHOUSES LIKE 'my_wh';