Database (source ETL/ELT)

(1) First select a database alias. Note: Variables (syntax @MYVAR@, type String) can also be used here. These are available via the drop-down menu.

(2) See section SQL Console.

(3) Here you can easily create the SQL query (4) with a wizard.

(4) The SQL query created by the wizard (3). The ETL/ELT source fields are created based on the name after the AS. You can also adjust it manually. In addition, you can insert WHERE conditions and use ETL/ELT variables in them, e.g. WHERE id_partner=@VAR_ID@ Note: The value of the variable can be passed, for example, by a workflow when it starts the pipeline. Important note: Please note that you can only customise the ETL/ELT source field names using the AS keyword. SELECT id_partner... therefore cannot be successfully changed to SELECT my_id_partner... to get the ETL/ELT source field my_id_partner, but only via SELECT id_partner AS 'my_id_partner'...

(5) Tests the SQL query (4) and returns the first row of the result set.