- 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.
- Snowflake – What It Is and Why It Exists
Start here. What Snowflake actually is — a SQL data warehouse you rent by the second, on somebody else's cloud — and what problem it was built to solve that Postgres and Hadoop did not. What you get on day one, what you pay for, when it is the wrong tool, and the lesson index for this track in reading order.
- LeetCode 7 – Reverse Integer
Tagged Easy, and it is not quite. Reversing the digits takes four lines; the problem is detecting 32-bit overflow without being allowed a 64-bit type. Two ways to check — undo the step, or rearrange the inequality — plus why Java's truncating % carries the sign for free, why Math.abs breaks on Integer.MIN_VALUE, and why Python needs the opposite care because its integers never overflow.