warehouse
Version 2.0
Retail sales star schema.
Subject areas
| Name | Description | Entities |
|---|---|---|
| Sales Star | The sales fact and its dimensions. | 5 |
Entities
Fact entities
| Name | Description | Attributes | Subject areas |
|---|---|---|---|
| fact_sales | One row per sold line item. | 10 | Sales Star |
Dimension entities
| Name | Description | Attributes | Subject areas |
|---|---|---|---|
| dim_customer | Customer dimension (type 1). | 5 | Sales Star |
| dim_date | Calendar dimension, one row per day. | 15 | Sales Star |
| dim_product | 5 | Sales Star | |
| dim_store | 4 | Sales Star |
Domains
| Name | Type | Null | Default | Check | Description |
|---|---|---|---|---|---|
| measure | decimal(18, 4) | no | 0 |
Enums
None.
Targets
| Name | Dialect | Schemas | Tables |
|---|---|---|---|
| bq | bigquery | 1 | 5 |
| dbx | databricks | 1 | 5 |
| mysql | mysql | 1 | 5 |
| pg | postgresql | 1 | 5 |
| rs | redshift | 1 | 5 |
| snow | snowflake | 1 | 5 |