- Snowflake – Loading Data with Stages and COPY INTO
Getting files in. Internal versus external stages, PUT and COPY INTO, file formats as reusable objects, why a hundred medium files load faster than one huge one, and what to do when a row fails — ON_ERROR, VALIDATION_MODE and the load metadata that silently skips a file you already loaded.
- Snowflake – Data Types That Matter
The short list worth knowing, and the three that cause real bugs. Why NUMBER is the only sensible choice for money, why VARCHAR(16777216) costs nothing extra, the three TIMESTAMP flavours and which one to standardise on, and VARIANT — the type that lets a column hold JSON and still be queried with SQL.
- Snowflake – Databases, Schemas and Tables
The object hierarchy and the DDL you will use every day. Permanent, transient and temporary tables and what the difference costs you, views versus materialised views, why Snowflake accepts a primary key and then ignores it, CREATE TABLE ... LIKE and CLONE, and the naming and identifier-casing rules that bite everyone exactly once.
- Snowflake – Virtual Warehouses and Sizing
The compute you are actually paying for. What a size means in credits, why doubling the size can cost the same as leaving it alone, auto-suspend and auto-resume and the one setting people get wrong, multi-cluster warehouses for concurrency versus a bigger warehouse for one slow query, and how to split workloads so a loading job cannot slow down a dashboard.
- Snowflake – Getting Started: Account, Worksheet and Connectors
From a trial signup to your first query against SNOWFLAKE_SAMPLE_DATA. Picking an edition and a region, the four things every session needs set, running SQL in Snowsight, and connecting from outside the browser — the Snowflake CLI, the Python connector and JDBC — with the key-pair auth you should use instead of a password.