Hi @RobTScot ,

I like hash key approach. The hash creates a deterministic fixed length key. Simply concat a bunch of strings will work but in general the length of the resulting key is much wider and not a fixed size.

For gold layer we just use identity column. That's because we use Power BI as our reporting tool of choice and choosing a string for a key is considered bad practice in PBI (the performance would be really bad).