Be able to set ApplicationIntent in external data sources
Enable Application Intent in External Data Sources. Azure External Data Sources cannot take advantage of Read Only replicas, even if accessed from a read only replica. The external data source has no way of signaling the Application Intent to the traffic manager. Thus they always point to the read write replica, regardless of how the client is configured.
I find it surprising that this is not possible. Microsoft have provided read-only scaleout for the purpose of offloading read queries, which requires specifying readonly application intent in the connection options, yet when creating an external data source in Azure SQL db there is no way to specify readonly application intent. Come on, Microsoft!