topic Does Delta format create a full copy of the data for each change I make to a table? in Data Engineering https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12188#M7042 Wed, 27 Jul 2022 17:32:53 GMT StephanieAlba 2022-07-27T17:32:53Z Does Delta format create a full copy of the data for each change I make to a table? https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12188#M7042 Wed, 27 Jul 2022 17:32:53 GMT https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12188#M7042 StephanieAlba 2022-07-27T17:32:53Z Re: Does Delta format create a full copy of the data for each change I make to a table? https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12189#M7043 <P>No it will just add/update/delete the changes in a transaction log for each write operation ​</P> Wed, 27 Jul 2022 18:58:42 GMT https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12189#M7043 Shasidhar_ES 2022-07-27T18:58:42Z Re: Does Delta format create a full copy of the data for each change I make to a table? https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12190#M7044 <P>the underlying data format is parquet. parquet is immutable so if one of the parquet files has to be changed, a new version of that file is created (and the old one is kept for a while). The transaction log keeps track on what file is the current one.</P> Thu, 28 Jul 2022 11:27:22 GMT https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12190#M7044 -werners- 2022-07-28T11:27:22Z Re: Does Delta format create a full copy of the data for each change I make to a table? https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12191#M7045 <P>Hi @Stephanie Rivera​,</P><P></P><P>Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.</P> Wed, 17 Aug 2022 21:24:08 GMT https://community.databricks.com/t5/data-engineering/does-delta-format-create-a-full-copy-of-the-data-for-each-change/m-p/12191#M7045 jose_gonzalez 2022-08-17T21:24:08Z