- Snowflake – Putting It in Production
The checklist between a working warehouse and one other people depend on. Separating dev, staging and production, versioning DDL in git and deploying it in CI, key-pair auth and network policies for service accounts, monitoring and alerting on the views that matter, and the failure modes worth having an answer for before they happen.
- Snowflake – Understanding and Controlling Cost
Where the credits actually go, and the handful of changes that move the bill most. Reading ACCOUNT_USAGE for warehouse, storage and serverless spend, resource monitors that suspend rather than warn, the auto-suspend and idle-warehouse waste everybody has, and why the fastest query is usually also the cheapest one.
- Snowflake – Roles, Grants and Access Control
Snowflake's RBAC in the order you need to understand it. Why ACCOUNTADMIN is not your working role, ownership versus grants, future grants — the single feature that stops permissions rotting every time someone adds a table — and a functional role layout you can copy. Plus masking policies and row access policies, briefly.
- Snowflake – Streams and Tasks
Native change tracking and scheduling, so a pipeline needs no extra orchestrator. What a stream really is (an offset, not a copy), the consumption rule that surprises everyone, task trees and serverless tasks, and the standard pattern: a stream feeds a MERGE, a task runs it only when there is something to do.
- Snowflake – Time Travel, Cloning and Undrop
The two features that change how you work, not just what you can recover. Querying a table as it was before the bad UPDATE, UNDROP, zero-copy clones that give you a full copy of production for a dev branch at no storage cost, and Fail-safe — which is Snowflake's insurance policy, not your backup.