Design star or snowflake schemas with fact and dimension tables, grain definition, and slowly changing dimensions.
## 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 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro