Helpful Snowflake Tutorials
September 9, 2026 · PowderInsights Team
How Snowflake account replication really works: replication versus failover groups, what does and does not replicate, client redirect with connection URLs, RPO/RTO tuning, cost, and a step-by-step failover and failback drill.
Read moreSeptember 9, 2026 · PowderInsights Team
A practical tuning workflow for slow Snowflake queries: find the real offenders in QUERY_HISTORY, read the Query Profile, fix partition pruning, decide between clustering keys and the Search Optimization Service, kill spill and exploding joins, and use QAS instead of a bigger warehouse.
Read moreSeptember 9, 2026 · PowderInsights Team
A hands-on walkthrough of the Snowflake Native App Framework: application packages and versions, manifest privileges and references, an idempotent setup script, shared data, Streamlit and container components, upgrade discipline, and Marketplace or private listing distribution.
Read moreSeptember 9, 2026 · PowderInsights Team
How the Model Context Protocol fits Snowflake: standing up an MCP server over Cortex Analyst and Cortex Search, wiring Cortex Agents for multi-step tool use, and the RBAC, cost, and audit controls that keep agentic access safe.
Read moreSeptember 9, 2026 · PowderInsights Team
A hands-on tutorial for building governance you can deploy from Git: object tagging, tag-based dynamic masking, row access policies with mapping tables, aggregation and projection constraints, data quality with data metric functions, and how to verify it all with ACCESS_HISTORY.
Read more