cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How can I convert a parquet into delta table?

mp
New Contributor II

I am looking to migrate my legacy warehouse data. How can I convert a parquet into delta table?

2 REPLIES 2

spark-user
Contributor

Hi mp,

You have two options to convert a parquet into a delta table through SQL

CONVERT TO DELTA parquet.`/data-pipeline/`
CREATE TABLE events USING DELTA LOCATION '/data-pipeline/'

or

CREATE TABLE events USING PARQUET OPTIONS (path '/data-pipeline/')
CONVERT TO DELTA events

If you want to learn about the differences between the two, there is actually a document on Databricks that explains it in detail

https://docs.databricks.com/delta/porting.html

Thank you

how about the scenario where your table is external and partitioned with files in s3?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group