Skip to main content

Querying for Snowflakes

Querying in Snowflake uses standard SQL with extensions for semi-structured data. JSON, Avro and Parquet values are stored in the VARIANT type and read with path notation and functions like FLATTEN. Other features include time travel queries, result caching and common table expressions, which make exploration fast and repeatable.

Stage: Data Loading · Part of the Snowflake roadmap · Last reviewed 19 November 2026

What to learn in Querying

Querying interview questions

What does FLATTEN do in Snowflake?

FLATTEN is a table function that turns each element of an array or object in a VARIANT value into its own row. Used with LATERAL, it lets you join an array back to its parent row and filter or aggregate the elements with plain SQL.

What is time travel?

Time travel lets you query, clone or restore data as it existed at an earlier point within the retention period, using AT or BEFORE clauses, and UNDROP for dropped objects. It helps recover from mistakes. The retention length depends on edition and settings.

Where Querying fits in the Snowflake roadmap

Querying belongs to the Data Loading stage (intermediate level). Get data in and out.

Back to the full Snowflake roadmap