Consider the following best practices while using Full Pushdown Optimization (PDO) over Azure SQL Data Warehouse:
Full PDO provides better performance for all supported transformations and their combinations over Azure SQL Data Warehouse V3 connector.
Scaling Data Warehouse Units in Azure SQL Data Warehouse provides better performance.
Operations such as insert, update, and delete in a full pushdown mapping perform on par when compared to executing SQL queries on tables in Azure SQL Data Warehouse from Azure SQL Data Warehouse Client or any third-party client.
Azure SQL Data Warehouse source and target are in the same region as Secure Agent.
ASK INFAPreview
