<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Hubs make key management easier (natural keys from hubs can be converted to surrogate keys via Identity columns). in Machine Learning</title>
    <link>https://community.databricks.com/t5/machine-learning/hubs-make-key-management-easier-natural-keys-from-hubs-can-be/m-p/14771#M786</link>
    <description>&lt;P&gt;In this blog &lt;A href="https://databricks.com/blog/2022/06/24/prescriptive-guidance-for-implementing-a-data-vault-model-on-the-databricks-lakehouse-platform.html" target="test_blank"&gt;https://databricks.com/blog/2022/06/24/prescriptive-guidance-for-implementing-a-data-vault-model-on-the-databricks-lakehouse-platform.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;It is mention that "Data Vault modeling recommends using a hash of business keys as the primary keys. Databricks supports &lt;A href="https://docs.databricks.com/sql/language-manual/functions/hash.html" alt="https://docs.databricks.com/sql/language-manual/functions/hash.html" target="_blank"&gt;hash&lt;/A&gt;, &lt;A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" alt="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" target="_blank"&gt;md5&lt;/A&gt;, and &lt;A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" alt="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" target="_blank"&gt;SHA&lt;/A&gt; functions out of the box to support business keys.".&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If my HUB primary keys are HASH then how it can be converted to identity columns in Gold Layer ???&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Mon, 04 Jul 2022 19:29:12 GMT</pubDate>
    <dc:creator>JD2</dc:creator>
    <dc:date>2022-07-04T19:29:12Z</dc:date>
    <item>
      <title>Hubs make key management easier (natural keys from hubs can be converted to surrogate keys via Identity columns).</title>
      <link>https://community.databricks.com/t5/machine-learning/hubs-make-key-management-easier-natural-keys-from-hubs-can-be/m-p/14771#M786</link>
      <description>&lt;P&gt;In this blog &lt;A href="https://databricks.com/blog/2022/06/24/prescriptive-guidance-for-implementing-a-data-vault-model-on-the-databricks-lakehouse-platform.html" target="test_blank"&gt;https://databricks.com/blog/2022/06/24/prescriptive-guidance-for-implementing-a-data-vault-model-on-the-databricks-lakehouse-platform.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;It is mention that "Data Vault modeling recommends using a hash of business keys as the primary keys. Databricks supports &lt;A href="https://docs.databricks.com/sql/language-manual/functions/hash.html" alt="https://docs.databricks.com/sql/language-manual/functions/hash.html" target="_blank"&gt;hash&lt;/A&gt;, &lt;A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" alt="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" target="_blank"&gt;md5&lt;/A&gt;, and &lt;A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" alt="https://docs.databricks.com/spark/latest/spark-sql/language-manual/functions/sha2.html" target="_blank"&gt;SHA&lt;/A&gt; functions out of the box to support business keys.".&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If my HUB primary keys are HASH then how it can be converted to identity columns in Gold Layer ???&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Mon, 04 Jul 2022 19:29:12 GMT</pubDate>
      <guid>https://community.databricks.com/t5/machine-learning/hubs-make-key-management-easier-natural-keys-from-hubs-can-be/m-p/14771#M786</guid>
      <dc:creator>JD2</dc:creator>
      <dc:date>2022-07-04T19:29:12Z</dc:date>
    </item>
  </channel>
</rss>

