SQL Models window

Admin |

ETL > ETL Domains > SQL Models

Note: if the ETL domain is locked, the window will open in read-only mode.

Purpose of window

This window allows you to define SQL syntax that can be reused as text or filters in the tasks of an ETL routine. With this centralised definition, every edit made to an SQL model has an impact on all tasks in which it is used, thus making it easier to maintain setups.

Attributes tab

Please find below the most important fields.

Field	Description
Code	the model’s unique ID
Description	description of the model
Text	Contains the SQL syntax. The ETL’s dynamic syntax can be used (see ETL syntax