<?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 Can't &amp;quot;copy into&amp;quot; new data to delta table after truncate old data in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/can-t-quot-copy-into-quot-new-data-to-delta-table-after-truncate/m-p/45815#M27986</link>
    <description>&lt;P&gt;Like title, i have a delta table with data of 22/9 and today i wanna remove old data and add new data of 23/9, i used 'truncate' and 'copy into' query but after 'truncate', nothing is added to table, what's happened with my table, file of old data still in location path, but nothing return when i run 'select' query&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Danh_Hoa_0-1695454173304.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3916iAC2365FB6C51CC63/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Danh_Hoa_0-1695454173304.png" alt="Danh_Hoa_0-1695454173304.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Danh_Hoa_1-1695454194171.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3917iE674B9CEED7B8C30/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Danh_Hoa_1-1695454194171.png" alt="Danh_Hoa_1-1695454194171.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 23 Sep 2023 07:30:52 GMT</pubDate>
    <dc:creator>Danh_Hoa</dc:creator>
    <dc:date>2023-09-23T07:30:52Z</dc:date>
    <item>
      <title>Can't "copy into" new data to delta table after truncate old data</title>
      <link>https://community.databricks.com/t5/data-engineering/can-t-quot-copy-into-quot-new-data-to-delta-table-after-truncate/m-p/45815#M27986</link>
      <description>&lt;P&gt;Like title, i have a delta table with data of 22/9 and today i wanna remove old data and add new data of 23/9, i used 'truncate' and 'copy into' query but after 'truncate', nothing is added to table, what's happened with my table, file of old data still in location path, but nothing return when i run 'select' query&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Danh_Hoa_0-1695454173304.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3916iAC2365FB6C51CC63/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Danh_Hoa_0-1695454173304.png" alt="Danh_Hoa_0-1695454173304.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Danh_Hoa_1-1695454194171.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/3917iE674B9CEED7B8C30/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Danh_Hoa_1-1695454194171.png" alt="Danh_Hoa_1-1695454194171.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 23 Sep 2023 07:30:52 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/can-t-quot-copy-into-quot-new-data-to-delta-table-after-truncate/m-p/45815#M27986</guid>
      <dc:creator>Danh_Hoa</dc:creator>
      <dc:date>2023-09-23T07:30:52Z</dc:date>
    </item>
  </channel>
</rss>

