Your First Snowflake Query

Analogy categoryAnalogies

Once your account, warehouse, database, and schema exist, running your first query is as simple as opening a worksheet in Snowsight (Snowflake's web UI), selecting a warehouse and database context, and typing standard ANSI SQL — Snowflake requires no proprietary query language, so anyone comfortable with SELECT, JOIN, and WHERE clauses can be productive immediately.

🏏

Cricket analogy: Like a batter who's trained in the standard MCC coaching manual being able to walk into any franchise's nets and bat effectively immediately, without learning a whole new technique — standard SQL works the same way across warehouses.

Using Worksheets and Snowsight

Snowsight organizes your work into worksheets, each of which remembers its own context (which role, warehouse, database, and schema it's currently using), so you can have one worksheet exploring raw ingestion tables under RAW_DB and another building aggregate reports under ANALYTICS_DB without constantly switching context back and forth. Results appear in a grid below the editor, and Snowsight can auto-generate quick chart visualizations directly from a result set without exporting anywhere.

🏏

Cricket analogy: Like a coach keeping separate notebooks for the Test squad and the T20 squad, each remembering its own lineup and strategy, so flipping between them never mixes up which format you're planning for.

Writing a SELECT Query

A basic query sets context with USE WAREHOUSE and USE DATABASE/USE SCHEMA statements, then runs a SELECT — for example, filtering orders by date and aggregating revenue by region uses the same GROUP BY and ORDER BY syntax you'd use in PostgreSQL or MySQL, since Snowflake's SQL dialect is deliberately close to ANSI standard SQL with only a handful of Snowflake-specific extensions like QUALIFY for filtering window function results.

🏏

Cricket analogy: Like using the standard scorebook format everyone learns, but adding one extra column like 'DRS reviews used' that's specific to modern cricket — QUALIFY is that one extra Snowflake column bolted onto otherwise familiar SQL.

sql

USE WAREHOUSE COMPUTE_WH;
USE DATABASE SNOWFLAKE_SAMPLE_DATA;
USE SCHEMA TPCH_SF1;

SELECT
    o_orderdate,
    o_totalprice,
    RANK() OVER (PARTITION BY o_custkey ORDER BY o_totalprice DESC) AS price_rank
FROM orders
QUALIFY price_rank = 1
ORDER BY o_totalprice DESC
LIMIT 10;

Loading Sample Data and Querying It

Snowflake ships every account with a free sample database called SNOWFLAKE_SAMPLE_DATA (based on the TPC-H benchmark) containing realistic tables like ORDERS, CUSTOMER, and LINEITEM, so a beginner can practice real analytical queries — joins across millions of rows, aggregations, subqueries — without loading a single byte of their own data first.

🏏

Cricket analogy: Like a rookie practicing decision-making using archived footage of real historic matches before ever playing a live game, Snowflake's sample TPC-H data lets beginners run real analytical queries before loading their own data.

Snowsight's worksheet automatically shows query execution details (bytes scanned, partitions pruned, time breakdown) in the 'Query Details' panel — checking it after your first few queries is the fastest way to build intuition for how partition pruning and caching affect performance.

Snowsight is Snowflake's web UI; worksheets each remember their own role, warehouse, and schema context.
Snowflake's SQL dialect is close to ANSI standard SQL, so existing SQL knowledge transfers directly.
Set context with USE WAREHOUSE and USE DATABASE/SCHEMA before running queries.
QUALIFY is a Snowflake-specific extension for filtering on window function results.
SNOWFLAKE_SAMPLE_DATA provides a free TPC-H-based dataset for practicing real queries.
Snowsight can auto-generate charts directly from a query result grid.
Query Details panel shows bytes scanned and partitions pruned, useful for learning performance behavior.

Practice what you learned

1. What must you select before running a query in a Snowsight worksheet?

2. How close is Snowflake's SQL dialect to ANSI standard SQL?

3. What does the QUALIFY clause do?

4. What is SNOWFLAKE_SAMPLE_DATA?

5. What can Snowsight generate directly from a query result grid?

Was this page helpful?

Databases, Schemas, and Warehouses

Related Study Notes in Programming

Browse all study notes

Programming

Apache Spark Study Notes

Programming · 30 topics

Programming

Apache Flink Study Notes

Programming · 30 topics

Programming

Hadoop Study Notes

Programming · 30 topics

Programming

Apache Airflow Study Notes

Programming · 30 topics

Programming

dbt (Data Build Tool) Study Notes

Programming · 30 topics

Programming

PowerShell Study Notes

Programming · 30 topics

Topics covered

#Programming#SnowflakeStudyNotes#YourFirstSnowflakeQuery#Snowflake#Query#Worksheets#Snowsight#SQL#StudyNotes#SkillVeris

Your First Snowflake Query