Surrogate keys or not?
So I'm translating a SQL server solution into Fabric. I had set up my SCD2 in SQL server with surrogate keys but I'm completely unclear whether they are needed in Fabric. Co-Pilot is telling me to use the natural business key and hash the columns for comparisons, throwing away the surrogate key concept at silver level. Is this a generally accepted stance or am I missing something?
u/First_Newspaper_612 — 3 days ago