topic Re: How can I convert a parquet into delta table? in Data Engineering

How can I convert a parquet into delta table?

mp — Sat, 25 Sep 2021 05:26:22 GMT

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

spark-user — Sat, 25 Sep 2021 06:12:28 GMT

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/'

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

Thank you

saipardhu — Mon, 22 Aug 2022 04:19:23 GMT

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