, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.
The amount of transformation logic that you can push to the database depends on the database, transformation logic, and task configuration. The Secure Agent processes all transformation logic that it cannot push to the database.
Configure
SQL ELT optimization
for a mapping in the tasks properties.
You can configure
SQL ELT optimization
in task that references a mapping or a mapping in advanced mode.
You can only configure
SQL ELT optimization
when you use the SQL warehouse to connect to Databricks Delta.