https://community.databricks.com/t5/data-engineering/what-are-the-different-methods-to-implement-surrogate-keys-in/m-p/15253#M9609 <P>There are various methods like using uuid , monotonically_increasing_id(), using row_number() OVER (ORDER BY NULL) AS SK, using md5() or sha() hashing functions etc. Detailed discussion of various options and the pros/cons can be found in this youtube talk - <A href="https://www.youtube.com/watch?v=aF2hRH5WZAU" target="test_blank">https://www.youtube.com/watch?v=aF2hRH5WZAU</A> </P><P></P><P></P> Thu, 16 Sep 2021 00:15:57 GMT User16826992724 2021-09-16T00:15:57Z https://community.databricks.com/t5/data-engineering/what-are-the-different-methods-to-implement-surrogate-keys-in/m-p/15252#M9608 Thu, 16 Sep 2021 00:06:56 GMT https://community.databricks.com/t5/data-engineering/what-are-the-different-methods-to-implement-surrogate-keys-in/m-p/15252#M9608 User16826992724 2021-09-16T00:06:56Z https://community.databricks.com/t5/data-engineering/what-are-the-different-methods-to-implement-surrogate-keys-in/m-p/15253#M9609 <P>There are various methods like using uuid , monotonically_increasing_id(), using row_number() OVER (ORDER BY NULL) AS SK, using md5() or sha() hashing functions etc. Detailed discussion of various options and the pros/cons can be found in this youtube talk - <A href="https://www.youtube.com/watch?v=aF2hRH5WZAU" target="test_blank">https://www.youtube.com/watch?v=aF2hRH5WZAU</A> </P><P></P><P></P> Thu, 16 Sep 2021 00:15:57 GMT https://community.databricks.com/t5/data-engineering/what-are-the-different-methods-to-implement-surrogate-keys-in/m-p/15253#M9609 User16826992724 2021-09-16T00:15:57Z