
How to Use IDENTITY Columns in Fabric Data Warehouse for Surrogate Keys
“Every company is now an AI company. The question is whether every worker will be an AI worker.” — Satya Nadella But before any of that AI promise becomes real, someone has to build the pipes. And anyone who has spent time building data warehouses knows that a surprising amount of that work isn’t sophisticated. It’s repetitive. Writing MAX(ID) + 1 for the hundredth time. Adding ROW_NUMBER()


