...
This will be archived by utilizing a raw model, and materialized views will be built on top of raw tables for Business Users (BU)s.
Model Layers
- Physical Tables.
- Staging Tables
- Raw Tables
- Transaction JSON object.
- Rarely change, requires
- Standing View Layer
- Views to bring raw to logical
- Views to allow for BU analysis with less joins
- More will be added with time, less governance on adding.
- Dynamic View Layer
- Support Specific Extraction Patterns
- Persistent after deployed.
- Query Layer
- ?