https://community.databricks.com/t5/data-engineering/how-to-create-a-surrogate-key-sequence-which-i-can-use-in-scd/m-p/28196#M20019 <P></P> <P>Hi <A href="https://users/30242/pascalvanbellen.html" target="_blank">@pascalvanbellen</A> ,There is no concept of FK, PK, SK in Spark. But Databricks Delta automatically takes care of SCD type scenarios. <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/merge-into.html#slowly-changing-data-scd-type-2" target="test_blank">https://docs.databricks.com/spark/latest/spark-sql/language-manual/merge-into.html#slowly-changing-data-scd-type-2</A></P> <P>If you want to make up SK concept in Spark here, please read my blog.</P> <P><A href="https://hadoopist.wordpress.com/2016/05/24/generate-unique-ids-for-each-rows-in-a-spark-dataframe/" target="test_blank">https://hadoopist.wordpress.com/2016/05/24/generate-unique-ids-for-each-rows-in-a-spark-dataframe/</A></P> <P></P> Wed, 17 Apr 2019 21:43:39 GMT girivaratharaja 2019-04-17T21:43:39Z https://community.databricks.com/t5/data-engineering/how-to-create-a-surrogate-key-sequence-which-i-can-use-in-scd/m-p/28195#M20018 <P></P> <P>Hi Community </P> <P>I would like to know if there is an option to create an integer sequence which persists even if the cluster is shut down. My target is to use this integer value as a surrogate key to join different tables or do Slowly changing dimension cases.</P> <P></P> Wed, 17 Apr 2019 06:50:04 GMT https://community.databricks.com/t5/data-engineering/how-to-create-a-surrogate-key-sequence-which-i-can-use-in-scd/m-p/28195#M20018 Pascalvan_Belle 2019-04-17T06:50:04Z https://community.databricks.com/t5/data-engineering/how-to-create-a-surrogate-key-sequence-which-i-can-use-in-scd/m-p/28196#M20019 <P></P> <P>Hi <A href="https://users/30242/pascalvanbellen.html" target="_blank">@pascalvanbellen</A> ,There is no concept of FK, PK, SK in Spark. But Databricks Delta automatically takes care of SCD type scenarios. <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/merge-into.html#slowly-changing-data-scd-type-2" target="test_blank">https://docs.databricks.com/spark/latest/spark-sql/language-manual/merge-into.html#slowly-changing-data-scd-type-2</A></P> <P>If you want to make up SK concept in Spark here, please read my blog.</P> <P><A href="https://hadoopist.wordpress.com/2016/05/24/generate-unique-ids-for-each-rows-in-a-spark-dataframe/" target="test_blank">https://hadoopist.wordpress.com/2016/05/24/generate-unique-ids-for-each-rows-in-a-spark-dataframe/</A></P> <P></P> Wed, 17 Apr 2019 21:43:39 GMT https://community.databricks.com/t5/data-engineering/how-to-create-a-surrogate-key-sequence-which-i-can-use-in-scd/m-p/28196#M20019 girivaratharaja 2019-04-17T21:43:39Z