We launched today our Fabric DWA Framework Accelerator. This is the result of over 3,500 hours of work migrating our Synapse DWA Framework to Fabric and also re-designing the template library system to make it extensible enough to handle any and all Fabric artefacts like Pipelines, Dataflows, Notebooks as well as traditional SQL Procedures and … Continue reading Fabric DW Automation Now Available!
Author: Bob Duffy
Why do we need sequential identity in data warehousing? Currently Fabric doesnt support Identity columns. Even if/when it does, I assume that the numbers won't be sequential as most MPPs such as SqlPools generate different ranges per "node" as per Synapse, resulting in numbers that may be unique but look somewhat random. https://azurede.com/2021/07/31/comparing-sql-server-and-synapse-analytics-identity-columns/ First up, … Continue reading Sequential Identity in Fabric