You can configure SQL ELT when you want the mapping logic to be processed by your cloud ecosystem.
Configure SQL ELT in one of the following ways:
Create a mapping in SQL ELT mode
In a mapping in SQL ELT mode, you don't have to specify an optimization type. Data Integration pushes the transformation logic by default to the target database.
You can also preview data for individual transformations to validate the mapping logic.
When you run a mapping in SQL ELT mode, you can load data from the following data sources to Snowflake:
If you want to push some or all the transformation logic based on the selected optimization type, you can add the mapping or mapping in advanced mode to a mapping task, and enable SQL ELT optimization in the mapping task. Data Integration pushes the transformation logic to the source or target database based on the optimization type you specify in the task properties. On the Runtime Options tab, you can configure Full, Source, and other optimization configurations. Data Integration processes any transformation logic that isn't pushed to the sources and targets.
When you create mappings and enable SQL ELT optimization in a mapping task, you can load data from the following data sources to Snowflake: