FIXME: elaborate more: Data warehouse tables could be constructed with two types of tables: - fact tables - events as occurred in time, such as sales, alerts, etc - dimension tables - static data Examples: - [date dimension for BigQuery](https://gist.github.com/richardsalt/ce7045336a1b2bedf1aef1e2ffd31899) ![[Screenshot 2022-05-10T14.15.png]] - [Star schema - Wikipedia](https://en.wikipedia.org/wiki/Star_schema)