I have a need to create Managed Queries to sub-select data ranges from a large table source to improve load performance.
This is an on-premise SQL instance going to a Gen 2 Storage account in Azure.
We have selected ADF because it provides the best performance with the transfer. We are still finding that we have performance issues and so want to break 2 of the larger tables into sub loads so that we can create multiple tables in the Gen 2 storage to leverage parallel loads into the Prepare instance.
I was going to use managed queries to accomplish this but it does not appear to be an option on ADF Transfer. Can you confirm?
