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 Packages List ETL packages that group transformations and workflows.
Scripts Scripts Contain SQL or script-based transformations for ETL.
Imports Imports Manage import processes from external sources into the warehouse.
Historizations Historizations Handle slowly changing dimensions and historical data tracking.
Transformations Transformations Define transformation logic for staging and warehouse layers.
Calendar New Transformation — Calendar Dimension Generates a reusable calendar dimension (year, month, day, etc.).
Time New Transformation — Time Dimension Creates a detailed time dimension (hours, minutes, seconds).
Snapshot New Transformation — Snapshot Dimension Creates snapshot dimensions to capture point-in-time records.