Cheat Sheets

Snowflake Cheat Sheet

Quick reference for Snowflake — from virtual warehouses and data loading to Time Travel, cloning, streams, tasks, and access control.

Load. Query. Scale. Share.

Tap for definition · Hold to copyHover for definition · Click to copy

Virtual Warehouses

CREATE WAREHOUSEALTER WAREHOUSESUSPEND / RESUMEUSE WAREHOUSESHOW WAREHOUSES

Databases & Schemas

CREATE DATABASECREATE SCHEMAUSE DATABASE / SCHEMASHOW DATABASES

Querying

Basic SELECTQUALIFYSAMPLEPIVOTUNPIVOTResult Cache

Data Loading

CREATE STAGEPUT (upload file)COPY INTO (load)COPY INTO (unload)Snowpipe

Semi-Structured Data

VARIANT typeParse JSONDot / colon notationFLATTENOBJECT_CONSTRUCTARRAY_AGG

Time Travel

Query past dataUNDROPSet retention period

Cloning

CLONE tableCLONE databaseClone at point in time

Streams & Tasks

CREATE STREAMQuery a streamCREATE TASKEXECUTE TASK

Access Control

CREATE ROLEGRANT privilegeREVOKEUSE ROLERow-level security

Performance & Optimisation

Clustering keysEXPLAINQuery ProfileMaterialized viewSearch optimisation