Allow connections from Data Factory to Azure SQL DB read scale-out replicas

[DHarmon1]

https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql As part of High Availability architecture, each single database or elastic pool database in the Premium and Business Critical service tier is automatically provisioned with a primary read-write replica and one or more secondary read-only replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The read scale-out feature allows you to offload read-only workloads using the compute capacity of one of the read-only replicas, instead of running them on the read-write replica. This way, some read-only workloads can be isolated from the read-write workloads, and don't affect their performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics. In the Premium and Business Critical service tiers, applications could gain performance benefits using this additional capacity at no extra cost. I would like to use the Azure Data Factory in Microsoft Fabric to copy over large tables from our production databases for the initial load of a data warehouse. Since this is a copy operation, I would like to use the read scale out instance so that I do not impact the production database. However, the ADF Connector for an Azure SQL Database does not provide the functionality to set ApplicationIntent=ReadOnly in the connection string so that I can connect to the read scale out. The ask is to provide a check box in the Azure SQL Database connector that will add the configuration option "ApplicationIntent=ReadOnly" to the connection string so that I can connect to the read scale out instance and not impact my production databases.