ETL
ETL
The ETL menu contains development assets for extraction, transformation, and loading. Group work into packages, write scripts, manage imports, and handle historization scenarios with reusable transformations and generated dimensions.
Icon | Feature | Description |
---|---|---|
Packages | List ETL packages that group transformations and workflows. | |
Scripts | Contain SQL or script-based transformations for ETL. | |
Imports | Manage import processes from external sources into the warehouse. | |
Historizations | Handle slowly changing dimensions and historical data tracking. | |
Transformations | Define transformation logic for staging and warehouse layers. | |
New Transformation — Calendar Dimension | Generates a reusable calendar dimension (year, month, day, etc.). | |
New Transformation — Time Dimension | Creates a detailed time dimension (hours, minutes, seconds). | |
New Transformation — Snapshot Dimension | Creates snapshot dimensions to capture point-in-time records. |