Can I convert parquet files to Delta?

User16826992666
Databricks Employee
Databricks Employee

‎06-16-2021 07:57 PM

I am already storing my data as parquet files and have registered them as a table in Databricks. If I want to convert the table to be a Delta table, do I have to do a full read of the data and rewrite it in the Delta format?

0 Kudos

Srikanth_Gupta_
Databricks Employee
Databricks Employee

‎06-17-2021 01:11 PM

We can convert Parquet table to Delta using below command

CONVERT TO DELTA <table_name>

CONVERT TO DELTA parquet.<location>

its better to provide table name so that metastore also gets updated, also it would be good idea to avoid update/insert new data while converting to Delta.

View solution in original post

0 Kudos

User16752244127
Databricks Employee
Databricks Employee

‎08-12-2021 06:23 AM

more details and programmatic options can be found in the Porting Guide.

0 Kudos