When you configure a mapping to write to multiple Databricks Delta targets, you can further optimize the write operation when you configure full

SQL ELT optimization

.

To optimize, you can configure an insert, update, upsert, or delete operation for multiple targets individually.

You can select the same Databricks Delta target table in multiple Target transformations and perform different operations for each of the Target transformations to run independent of each other.

If your mapping contains multiple pipelines, you can define the flow run order to load the targets from the pipelines in a particular order.