https://community.databricks.com/t5/data-engineering/converting-data-that-is-in-delta-format-to-plain-parquet-format/m-p/21166#M14384 <P>You can easily convert a Delta table back to a Parquet table using the following steps:</P><OL><LI>If you have performed Delta Lake operations that can change the data files (for example, delete&nbsp;or&nbsp;merge, run&nbsp;<A href="https://docs.databricks.com/delta/delta-utility.html#delta-vacuum" alt="https://docs.databricks.com/delta/delta-utility.html#delta-vacuum" target="_blank">vacuum</A>&nbsp;with retention of 0 hours to delete all data files that do not belong to the latest version of the table.</LI><LI>Delete the&nbsp;_delta_log directory in the table directory.</LI></OL><P>Refrence​ and mir info - <A href="https://docs.databricks.com/delta/delta-utility.html#convert-a-delta-table-to-a-parquet-table" target="test_blank">https://docs.databricks.com/delta/delta-utility.html#convert-a-delta-table-to-a-parquet-table</A></P><P>​</P> Thu, 24 Jun 2021 01:11:30 GMT User16826994223 2021-06-24T01:11:30Z https://community.databricks.com/t5/data-engineering/converting-data-that-is-in-delta-format-to-plain-parquet-format/m-p/21165#M14383 <P>Many a times there is a need to convert Delta tables from Delta format to plain parquet format for a number of reasons, what is the best way to do that? </P> Wed, 23 Jun 2021 21:36:44 GMT https://community.databricks.com/t5/data-engineering/converting-data-that-is-in-delta-format-to-plain-parquet-format/m-p/21165#M14383 User16783853501 2021-06-23T21:36:44Z https://community.databricks.com/t5/data-engineering/converting-data-that-is-in-delta-format-to-plain-parquet-format/m-p/21166#M14384 <P>You can easily convert a Delta table back to a Parquet table using the following steps:</P><OL><LI>If you have performed Delta Lake operations that can change the data files (for example, delete&nbsp;or&nbsp;merge, run&nbsp;<A href="https://docs.databricks.com/delta/delta-utility.html#delta-vacuum" alt="https://docs.databricks.com/delta/delta-utility.html#delta-vacuum" target="_blank">vacuum</A>&nbsp;with retention of 0 hours to delete all data files that do not belong to the latest version of the table.</LI><LI>Delete the&nbsp;_delta_log directory in the table directory.</LI></OL><P>Refrence​ and mir info - <A href="https://docs.databricks.com/delta/delta-utility.html#convert-a-delta-table-to-a-parquet-table" target="test_blank">https://docs.databricks.com/delta/delta-utility.html#convert-a-delta-table-to-a-parquet-table</A></P><P>​</P> Thu, 24 Jun 2021 01:11:30 GMT https://community.databricks.com/t5/data-engineering/converting-data-that-is-in-delta-format-to-plain-parquet-format/m-p/21166#M14384 User16826994223 2021-06-24T01:11:30Z