When transforming data with ADF, it is imperative that your data warehouse & ETL processes are fully secured and are able to load vast amounts of data in the limited time windows that you are provided by your business stakeholders. ADF Data Flows have added support for managed identity and service principal with data flows when loading into Synapse Analytics (formerly SQL DW) in order to fully support this scenario. Now, you can connect from ADF to your ADLS Gen2 staging account in a secure manner from Source, Sink, and Staging.
