Variables (ETL/ELT)
In this menu you can create, modify, delete ETL/ELT variables and import them from profiles or workflows.
(1) See table below.
(2) See table below.
(3) Creates a new variable.
(4) The context menu can be used to import variables from a specific profile or workflow into the ETL/ELT pipeline. Via Export variables can be exported as CSV file.
(5) When calling an ETL/ELT pipeline via a workflow, the values of workflow variables are passed to ETL/ELT variables with the same name. For this, however, this option here must be set for these ETL/ELT variables.
ETL/ELT System Variables
|
BASE_PATH |
Is automatically set to the path of the _data installation directory. Note: Changes have no effect because the value is always set again automatically. |
|
TEST_PATH |
Analogous to BASE_PATH for test runs. |
|
JOB_ID |
Will be filled with the ID of the job at runtime. |
|
LAST_RUN |
The time of the last run of the ETL/ELT pipeline. |