Converting data that is in Delta format to plain parquet format

User16783853501
Databricks Employee
Databricks Employee

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?

User16826994223
Databricks Employee
Databricks Employee

You can easily convert a Delta table back to a Parquet table using the following steps:

  1. If you have performed Delta Lake operations that can change the data files (for example, delete or merge, run vacuum with retention of 0 hours to delete all data files that do not belong to the latest version of the table.
  2. Delete the _delta_log directory in the table directory.

Refrence​ and mir info - https://docs.databricks.com/delta/delta-utility.html#convert-a-delta-table-to-a-parquet-table