In a task enabled with SQL ELT optimization, you can select the optimization type to push some or all the transformation logic. Data Integration pushes the transformation logic to the source or target database based on the optimization type you specify in the task properties.
To enable SQL ELT optimization, add the configured mapping
or mapping in advanced mode
to a mapping task, and then enable SQL ELT optimization in the mapping task.
You can configure Full, Source, and other optimization configurations in the
SQL ELT optimization
advanced session properties on the
Runtime Options
tab. Data Integration processes any transformation logic that isn't pushed to the sources and targets on the on the Data Integration Server and on an advanced cluster.
You can enable SQL ELT optimization in a mapping task to load data from the following data sources to Databricks:
ASK INFAPreview
