Convert to Delta Lake

The CONVERT TO DELTA SQL command coverts Parquet and Iceberg tables to Delta Lake tables.

For the technical documentation, see CONVERT TO DELTA.

Converting a directory of Parquet or Iceberg files in an external location to Delta Lake

You can convert a directory of Parquet data files to a Delta Lake table as long as you have write access on the storage location.

You can then register these files as a table in the Hive metastore.

Note

For Databricks Runtime 11.2 and above, CONVERT TO DELTA automatically infers partitioning information for tables registered to the metastore, eliminating the requirement to manually specify partitions.