Helpful Snowflake Tutorials
September 11, 2026 · PowderInsights Team
A working Terraform setup for Snowflake with the snowflakedb provider v2: key-pair service auth, databases and Gen2 warehouses, authoritative grant resources for a functional/access role model, config-driven import of an existing account, and CI plan/apply guardrails.
Read moreSeptember 10, 2026 · PowderInsights Team
How to design a Snowflake role model that scales: the two-layer functional/access role pattern, database roles for shares and Native Apps, future-grant traps, service identities, clone drift, and audit queries that catch violations.
Read moreSeptember 9, 2026 · PowderInsights Team
A hands-on SPCS tutorial: compute pools, image repositories, service specs, readiness probes, calling a container from SQL with service functions, the OAuth token trick, upgrades, and the cost hygiene that keeps idle pools from eating your credits.
Read moreSeptember 9, 2026 · PowderInsights Team
A hands-on Snowflake observability tutorial: create an event table, instrument stored procedures with logs and telemetry events, query spans, build failure and missing-run alerts, and keep the cost of monitoring under control.
Read moreSeptember 9, 2026 · PowderInsights Team
No-copy sharing end to end: secure views and direct shares, multi-tenant filtering with CURRENT_ACCOUNT(), reader accounts and their cost trap, private and Marketplace listings with cross-region auto-fulfillment, clean rooms, and the governance checklist to put in first.
Read more