Creating surrogate keys in gold layer data warehouse

Hi everyone!

Could anyone help out with the syntax for creating an autogenerated surrogate key column in a SQL create table statement. Something like adding an index column in a gen2 dataflow where you get an int value starting at 1 and increments by one for each new record. I've tried using the 'IDENTITY' and 'UNIQUE IDENTIFIER' keywords but they don't appear to be supported in fabric warehouses.

I am trying to implement type 2 SCD dimensions in a gold layer warehouse where customer information is read in from the silver layer and each customer has an id assigned by the source system but is assigned a new surrogate ID in the gold layer to track historical changes.

Thanks in advance!

3 comments