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
Pipeline: Activity-level Run Conditions (No IF Container Required)
We need the ability to add a "Run if" condition directly to every pipeline activity. Like, in each acticity's settings. One of the biggest readability issues in Fabric Pipelines is that conditional ...frithjof_v5 hours agoCommunity ChampionNew20Views2likes1CommentPipeline: New Routing activity as an improvement to IF and Switch
The current If Condition and Switch activities create large nested containers that own all activities inside their branches. These containers make the canvas much harder to read. Instead, add a lig...frithjof_v5 hours agoCommunity ChampionNew9Views0likes1CommentDisable Oracle Bundled Provider by Default or Allow Enterprise Administrative Control
Recent versions of Power BI Desktop enable the Oracle Bundled Provider preview feature by default, which can cause Oracle connectivity issues for organizations that rely on custom Oracle authenticati...ASkelt12 hours agoNew MemberNew9Views0likes0CommentsEnhance Workspace Throttling to Allow Targeted Limits on Individual Workspaces
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } The current workspace throttling design should be enhanced to allow Fabr...kyleleonard15 hours agoNew MemberNew28Views5likes0Comments