David Purdy on 29 Jun 2023 18:27:30
Identity columns are a common method for generating surrogate keys in data warehousing scenarios implemented on SQL Server. By adding support for identity columns in Fabric, users could migrate their warehouse workloads from SQL Server to Fabric, without having to make drastic changes to their data model or data load procedures. This would help to streamline the migration process, making Fabric a more attractive option for those looking to move their data warehouse to the new platform.
Peri Rocha (administrator)
Thanks for your feedback! This feature is currently planned for 2024.
UPDATE: while we're working to deliver this, if you currently need an alternative to IDENTITY columns you can use this workaround documented by our team: Generate unique identifiers in a warehouse table in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
- Comments (2)
RE: Add support for identity columns in Fabric warehouses.
Any update on this? I've not seen this listed on any of the release plans for Fabric.
RE: Add support for identity columns in Fabric warehouses.
Would be great to not only have IDENTITY() capability but also global sequencing like we have in TSQL IE:CREATE SEQUENCE (Transact-SQL) - SQL Server | Microsoft LearnThis would be super useful especially when you are tracking transactional data from multiple systems where 1: Same data is generated by disjointed transactional systems and2: Entry vector order matters3: multiple transaction tables are consolidated and the Surrogate key needs to be distinct and traceable