- 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.
- Snowflake – Architecture: Storage, Compute and Cloud Services
The three layers, and why every cost and performance decision later in this track comes back to them. Micro-partitions and how they replace the indexes you are used to, why two teams can query the same table at full speed without blocking each other, and what the services layer does for free — including the result cache that makes a repeated query cost nothing at all.