Helpful Snowflake Tutorials
September 21, 2026 · PowderInsights Team
Why queries queue instead of running, how to read QUERY_HISTORY queue columns, when to scale out with multi-cluster warehouses versus scale up, how the Query Acceleration Service actually helps, and a workload-isolation pattern that keeps dashboards fast without doubling the bill.
Read moreSeptember 21, 2026 · PowderInsights Team
A practical guide to Snowflake-native orchestration: building task graphs with finalizers, choosing serverless vs warehouse tasks, triggered tasks on streams, retry and error-handling patterns, TASK_HISTORY monitoring and alerts, and when to keep Airflow.
Read moreSeptember 21, 2026 · PowderInsights Team
Network rules and policies at account and user level, PrivateLink for private inbound and outbound connectivity, egress allow-lists for external access integrations, Trust Center verification, and a rollout order that will not lock you out.
Read moreSeptember 18, 2026 · PowderInsights Team
A practical modeling guide for Snowflake: why star schemas still win, when Data Vault earns its keep, hash keys and surrogate keys without sequences, SCD Type 2 with MERGE and with Dynamic Tables, and the clustering and constraint choices that decide query cost.
Read moreSeptember 17, 2026 · PowderInsights Team
Inventorying a Teradata estate from DBC views, what SnowConvert converts and what it leaves you, the dialect differences that bite (blank padding, PRIMARY INDEX, BTEQ, UPDATE...FROM), bulk data movement with TPT and COPY, replacing TASM with warehouses and resource monitors, and a reconciliation harness that proves equivalence.
Read more