Data Data Warehouse

Purpose

Design data warehouse schemas with dimensional modeling, platform-specific optimization, materialized views, and cost controls.

Agent Protocol

Trigger

Exact user phrases: "data warehouse", "Snowflake", "BigQuery", "Redshift", "star schema", "snowflake schema", "OLAP", "dimensional modeling", "fact table", "dimension table", "data warehouse design", "warehouse schema", "partition", "cluster", "materialized view", "warehouse optimization", "slowly changing dimension".

Input Context

Before activating, verify:

• Warehouse platform (Snowflake, BigQuery, Redshift, DuckDB)
• Data size and growth rate (TB scale, daily increment)
• Query patterns (dashboard, ad-hoc, ML feature extraction)
• Business domains (sales, marketing, finance, product)
• Compliance requirements (data retention, PII masking)