You can use SQL ELT optimization to push the transformation logic to Microsoft Azure Synapse SQL.
Use SQL ELT optimization to improve task performance by using the database resources. When you run a task configured for SQL ELT optimization, the task converts the transformation logic to a PolyBase query or SQL query. The task sends the query to the database, and the database executes the query.
Configure SQL ELT optimization for a mapping in the tasks properties. You can configure SQL ELT optimizationin task that references a mapping or a mapping in advanced mode.
If your mapping contains multiple pipelines, you can define the flow run order to load the targets from the pipelines in a particular order.