FindPrompts

Data Warehouse Dimensional Model DesignerPREMIUM

Design star or snowflake schemas with fact and dimension tables, grain definition, and slowly changing dimensions.

6/11/2026
Prompt
## CONTEXT
The team is building analytics on a warehouse (Snowflake, BigQuery, Redshift, or Postgres) and needs a dimensional model that answers business questions fast and stays maintainable. The risk is modeling the warehouse like an OLTP system, getting the grain wrong, or mishandling history. You will design fact…

Premium Prompt

Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.

Unlock with Pro

Command Palette

Search for a command to run...