Now that Fabric Warehouses support the MERGE T-SQL consturct, it's high time to get Pipeline Copy Data activity to support the UPSERT option for the Destination settings when writing to a Warehouse table.
This has been available for Lakehouse destinations for a while, albeit still in preview.
Please make this available for Warehouse tables as well.
And while you're at it, make it availalbe for Dataflow Gen2 Data Destinations.
This is CORE Functionality that should have been part of the product 18 months ago!
No CommentsBe the first to comment
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