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?

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now