https://community.databricks.com/t5/data-engineering/does-running-optimize-on-a-delta-table-destroy-the-transaction/m-p/21109#M14344 <P>No, you will still be able to time travel to versions previous to the OPTIMIZE command. </P><P></P><P>OPTIMIZE is just another transaction like MERGE, UPDATE, etc. </P><P></P><P><A href="https://docs.databricks.com/delta/delta-utility.html#remove-files-no-longer-referenced-by-a-delta-table" alt="https://docs.databricks.com/delta/delta-utility.html#remove-files-no-longer-referenced-by-a-delta-table" target="_blank">Check out these docs</A> to learn more about retention periods and the VACUUM command.</P> Wed, 23 Jun 2021 22:34:03 GMT cgrant 2021-06-23T22:34:03Z https://community.databricks.com/t5/data-engineering/does-running-optimize-on-a-delta-table-destroy-the-transaction/m-p/21108#M14343 <P>If I run OPTIMIZE on a Delta Lake table, will it prevent me from time travelling to a version before OPTIMIZE was run?</P> Wed, 23 Jun 2021 22:08:09 GMT https://community.databricks.com/t5/data-engineering/does-running-optimize-on-a-delta-table-destroy-the-transaction/m-p/21108#M14343 cgrant 2021-06-23T22:08:09Z https://community.databricks.com/t5/data-engineering/does-running-optimize-on-a-delta-table-destroy-the-transaction/m-p/21109#M14344 <P>No, you will still be able to time travel to versions previous to the OPTIMIZE command. </P><P></P><P>OPTIMIZE is just another transaction like MERGE, UPDATE, etc. </P><P></P><P><A href="https://docs.databricks.com/delta/delta-utility.html#remove-files-no-longer-referenced-by-a-delta-table" alt="https://docs.databricks.com/delta/delta-utility.html#remove-files-no-longer-referenced-by-a-delta-table" target="_blank">Check out these docs</A> to learn more about retention periods and the VACUUM command.</P> Wed, 23 Jun 2021 22:34:03 GMT https://community.databricks.com/t5/data-engineering/does-running-optimize-on-a-delta-table-destroy-the-transaction/m-p/21109#M14344 cgrant 2021-06-23T22:34:03Z