Snowflake SQL Cheat Sheet

CREATE WAREHOUSE IF NOT EXISTS etl_wh  WAREHOUSE_SIZE = 'MEDIUM'  AUTO_SUSPEND = 60  AUTO_RESUME = TRUE  INITIALLY_SUSPENDED = TRUE;USE WAREHOUSE etl_wh;ALTER WAREHOUSE etl_wh SET WAREHOUSE_SIZE = 'LARGE';-- Multi-cluster warehouse for high concurrencyALTER WAREHOUSE etl_wh SET  MIN_CLUSTER_COUNT = 1  MAX_CLUSTER_COUNT = 4  SCALING_POLICY = 'STANDARD';

CREATE TABLE events (raw VARIANT);INSERT INTO eventsSELECT PARSE_JSON('{"user": {"id": 42, "tier": "gold"}, "amount": 19.99}');SELECT    raw:user.id::INT           AS user_id,    raw:user.tier::STRING      AS tier,    raw:amount::FLOAT          AS amountFROM events;-- Flatten nested arraysSELECT f.value:sku::STRING AS skuFROM events, LATERAL FLATTEN(input => raw:items) f;

-- Query a table as of 1 hour agoSELECT * FROM orders AT (OFFSET => -3600);-- Query as of a specific timestampSELECT * FROM orders AT (TIMESTAMP => '2026-06-01 00:00:00'::TIMESTAMP);-- Restore an accidentally dropped tableUNDROP TABLE orders;-- Zero-copy clone (instant, no extra storage until divergence)CREATE TABLE orders_dev CLONE orders;CREATE DATABASE analytics_dev CLONE analytics_prod;