<?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 Delta Live Table Graph different with no change in Notebook code in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/delta-live-table-graph-different-with-no-change-in-notebook-code/m-p/43786#M27544</link>
    <description>&lt;P&gt;I have a DLT code to create 40+ bronze tables. The tables are created on top of the latest parquet files for each of those tables.&amp;nbsp;&lt;/P&gt;&lt;P&gt;While executing the pipeline, sometimes I notice that the graph is different than the regular one i see. I do not understand why that happens.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Graph i expect to see:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Manjula_Ganesap_0-1694001824330.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3518i98C1013883ED3E25/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Manjula_Ganesap_0-1694001824330.png" alt="Manjula_Ganesap_0-1694001824330.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Graph i see sometimes:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Manjula_Ganesap_1-1694001865082.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3519i2C6FC97826EA9DD2/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Manjula_Ganesap_1-1694001865082.png" alt="Manjula_Ganesap_1-1694001865082.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;As you can see from the screenshots - only 2 tables were created in the second run while all 40+ tables were created in the first run. The underlying parquet files were the same in both cases.&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 06 Sep 2023 12:05:51 GMT</pubDate>
    <dc:creator>Manjula_Ganesap</dc:creator>
    <dc:date>2023-09-06T12:05:51Z</dc:date>
    <item>
      <title>Delta Live Table Graph different with no change in Notebook code</title>
      <link>https://community.databricks.com/t5/data-engineering/delta-live-table-graph-different-with-no-change-in-notebook-code/m-p/43786#M27544</link>
      <description>&lt;P&gt;I have a DLT code to create 40+ bronze tables. The tables are created on top of the latest parquet files for each of those tables.&amp;nbsp;&lt;/P&gt;&lt;P&gt;While executing the pipeline, sometimes I notice that the graph is different than the regular one i see. I do not understand why that happens.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Graph i expect to see:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Manjula_Ganesap_0-1694001824330.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3518i98C1013883ED3E25/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Manjula_Ganesap_0-1694001824330.png" alt="Manjula_Ganesap_0-1694001824330.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Graph i see sometimes:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Manjula_Ganesap_1-1694001865082.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3519i2C6FC97826EA9DD2/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Manjula_Ganesap_1-1694001865082.png" alt="Manjula_Ganesap_1-1694001865082.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;As you can see from the screenshots - only 2 tables were created in the second run while all 40+ tables were created in the first run. The underlying parquet files were the same in both cases.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 06 Sep 2023 12:05:51 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/delta-live-table-graph-different-with-no-change-in-notebook-code/m-p/43786#M27544</guid>
      <dc:creator>Manjula_Ganesap</dc:creator>
      <dc:date>2023-09-06T12:05:51Z</dc:date>
    </item>
    <item>
      <title>Re: Delta Live Table Graph different with no change in Notebook code</title>
      <link>https://community.databricks.com/t5/data-engineering/delta-live-table-graph-different-with-no-change-in-notebook-code/m-p/43838#M27559</link>
      <description>&lt;P&gt;&lt;a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9"&gt;@Retired_mod&lt;/a&gt;&amp;nbsp; - Thank you for your response. There is no change in the table dependencies.&amp;nbsp;&lt;/P&gt;&lt;P&gt;The code to create the individual raw tables look like this: The input to this is always the same 40 tables with only the underlying parquet file changing. I cant understand why it creates 40 tables in the first run and then only 2 tables in the second run.&lt;/P&gt;&lt;DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;def&lt;/SPAN&gt;&lt;SPAN&gt; CreateTable(tableSchema,tableName, tableFilePath):&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; schemaTableName = &lt;/SPAN&gt;&lt;SPAN&gt;'test_dlt_'&lt;/SPAN&gt;&lt;SPAN&gt;+tableName.lower()&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN&gt;@dlt&lt;/SPAN&gt;&lt;SPAN&gt;.table(&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; name= schemaTableName,&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; comment=&lt;/SPAN&gt;&lt;SPAN&gt;"Raw data capture for "&lt;/SPAN&gt;&lt;SPAN&gt; + tableName,&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; table_properties={&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;&lt;SPAN&gt;"quality"&lt;/SPAN&gt;&lt;SPAN&gt;: &lt;/SPAN&gt;&lt;SPAN&gt;"bronze"&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;&lt;SPAN&gt;"pipelines.autoOptimize.managed"&lt;/SPAN&gt;&lt;SPAN&gt;: &lt;/SPAN&gt;&lt;SPAN&gt;"true"&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; }&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp;)&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN&gt;def&lt;/SPAN&gt;&lt;SPAN&gt; create_live_table():&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;&lt;SPAN&gt;return&lt;/SPAN&gt;&lt;SPAN&gt; (&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;(spark.read.&lt;/SPAN&gt;&lt;SPAN&gt;format&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"parquet"&lt;/SPAN&gt;&lt;SPAN&gt;).load(tableFilePath))&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; ) &amp;nbsp;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Wed, 06 Sep 2023 15:27:26 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/delta-live-table-graph-different-with-no-change-in-notebook-code/m-p/43838#M27559</guid>
      <dc:creator>Manjula_Ganesap</dc:creator>
      <dc:date>2023-09-06T15:27:26Z</dc:date>
    </item>
  </channel>
</rss>

