There are typically five categories of tables to build:
| Table type | Description |
|---|---|
| Source | From some external data source representing raw data |
| Staging | Light transformations on the raw data |
| Intermediate | Optional transformations on staging data |
| Fact | Represent things that have happened like event data (e.g. orders, clicks) |
| Dimension | Represent entities that exist |