Hi,
Today we can choose between ADO.NET and Azure Data Factory to transfer data from Ingest to Prepare in the config for the Prepare instance in the portal. However, these two have very different strengths. I would be great to be able to use ADO.NET for small tables and ADF for large ones, maybe by having an option in the configs of each of the the data sources in the portal. ADO.NET is much faster for small or incremental tables because of the substantial time it takes to start up each pipeline in ADF, while the data transfer itself is faster in ADF, and is therefore faster for larger tables.
