Snowflake Warehouse

Build on Snowflake — warehouses, tables, dynamic tables, Snowpark, Streamlit apps, RBAC, and cost controls. Generates DDL, governance configs, Terraform, and performance-optimized queries.

This skill writes production Snowflake assets: warehouse sizing strategies with auto-suspend, table DDL with clustering keys, Dynamic Tables for declarative pipelines, Streams + Tasks for incremental processing, Snowpark Python for in-database ML, Streamlit-in-Snowflake apps, RBAC role hierarchies, resource monitors with cost alerts, and Terraform via the Snowflake provider. Covers Iceberg tables and Cortex AI functions.

When to use

Use when modeling new Snowflake schemas, optimizing slow queries or runaway warehouse costs, setting up governance, or building Snowpark and Streamlit apps inside the warehouse.

Examples

Dynamic Tables pipeline

Declarative incremental transformation

Convert this dbt incremental model into a Snowflake Dynamic Table with TARGET_LAG of 5 minutes, refresh mode AUTO, and the proper warehouse for cost control

Cost-control resource monitor

Stop runaway warehouses

Set up Snowflake resource monitors per warehouse with daily credit caps, email notifications at 75%, and SUSPEND at 100% — plus a query to find the top 10 most expensive queries last week