...
Each of the environments follows the same schema and is therefore composed of the following datasets:
- StagingSTG : Data layer identical to the source, collecting the data from Cloud Storage
- ODS ODS : Data layer with slight processing on the data without changing its structurelasted data loaded to STG table.
- DM DW: Layer of data where the data is processed in order to model it as the business wishes. This is the layer that is linked to Tableau.
- WDL CLC : Data layer where all the tables necessary for the various calculations are stored, but which will not be used in Tableau.
- Temp: Data layer where temporary tables appear, used in particular when updating data in the Staging layer.
- Delta: Data layer allowing the Staging layer to be updated incrementallyDPL : Views for all the tables that is used by Tableau.