DHarmon1
2 years agoNew Member
Status:
New
Allow connections from Data Factory to Azure SQL DB read scale-out replicas
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.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
- fbcideas_migusr2 hours agoNew MemberUnder Review381Views12likes4Comments
Display Table[Column] instead of Column Name in Conditional Formatting Dialogs
In large-scale Power BI semantic models, it is common to have identical column names across multiple fact and dimension tables. Examples include columns such as Status, Category, Region, Employee ID,...Manickambeeie4 hours agoNew MemberNew4Views0likes0CommentsNative SAP SuccessFactors and Active Directory Connectivity for Simplified Data Integration
Having native connectors for SAP SuccessFactors and Active Directory would eliminate the need for workarounds such as notebooks, custom scripts, or complex integration setups. Users should be able...João_Cristo5 hours agoNew MemberNew4Views0likes0CommentsAllow Azure Databricks streaming tables to be mirrored into Fabric
Mirroring an Azure Databricks Unity Catalog into Fabric silently drops streaming tables. They are not greyed out, not flagged, not explained. They simply do not appear in the picker, so there is no w..._taab6 hours agoNew MemberNew7Views0likes0Comments