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. Full SQL ELT optimizationis enabled by default in mapping tasks.
If your mapping contains multiple pipelines, you can define the flow run order to load the targets from the pipelines in a particular order.