What is Delta Lake?

What Delta Lake is, how its transaction log works, key features like time travel and MERGE, and how Delta Lake compares with Apache Iceberg for your lakehouse.

What is Delta Lake?

What Delta Lake is, how its transaction log works, key features like time travel and MERGE, and how Delta Lake compares with Apache Iceberg for your lakehouse.

What is Delta Lake?

What Delta Lake is, how its transaction log works, key features like time travel and MERGE, and how Delta Lake compares with Apache Iceberg for your lakehouse.

IN THIS GUIDE

No headings found on page

SHORT ANSWER

Delta Lake is an open-source storage layer that turns Parquet files in cloud object storage into reliable tables with ACID transactions, schema enforcement, time travel and scalable metadata. Databricks created it and open-sourced it in 2019. It's now a Linux Foundation project and the default table format in Databricks and Microsoft Fabric, so most lakehouse tables you query on those platforms are Delta tables.

Delta Lake is an open-source table format and storage layer that adds database-like reliability to Parquet files in object storage such as Azure Data Lake Storage or Amazon S3. Databricks created it, open-sourced it in 2019, and the Linux Foundation now hosts it. It’s the default table format in Databricks and in Microsoft Fabric’s OneLake.

How does Delta Lake work?

Each Delta table is a folder of Parquet data files plus a transaction log (the _delta_log directory). Every write, update or delete becomes an atomic commit in the log. Readers use the log to know exactly which files make up the current version of the table. That gives you:

  • ACID transactions: concurrent jobs can’t leave a table half-written.

  • Schema enforcement and evolution: bad records get rejected, and you can add new columns in a controlled way.

  • MERGE, UPDATE and DELETE: needed for upserts from change data capture and for GDPR deletion requests.

  • Time travel: you can query earlier versions for audits or to reproduce model training data.

  • Performance features: file statistics, data skipping, compaction and clustering speed up queries on large tables.

Why does it matter for enterprises?

Plain data lakes break easily. A failed job leaves partial files, a schema change corrupts downstream reports and nobody can say what the data looked like last month. Delta Lake fixes these problems while keeping your data in an open format you control. It’s the base of the data lakehouse and the medallion architecture.

Delta Lake vs. plain Parquet files

Capability

Plain Parquet in a data lake

Delta Lake table

Atomic writes

No

Yes

Updates and deletes

Rewrite files manually

MERGE, UPDATE, DELETE

Schema enforcement

No

Yes

Query earlier versions

No

Time travel

Streaming and batch on one table

Difficult

Supported

Reliable tables change how teams work. On a HIPAA-aligned Databricks platform we built on Azure for a nonprofit human-services organization, data scientists had been working in local environments, which made collaboration slow and error-prone. Moving them onto shared, governed tables, with Unity Catalog and MLOps pipelines for automated retraining, gave everyone the same version of the data.

Delta tables need routine care to stay fast and affordable. Compact many small files, cluster data on frequently filtered columns, vacuum old file versions past their retention period and watch table growth. Databricks can automate much of this, but you should still review your largest and most-queried tables regularly.

How RUBICON helps with Delta Lake

As a Databricks Partner, we design and tune Delta tables and pipelines through our data engineering team, including maintenance jobs that keep query costs under control. If your tables have grown slow or expensive, our engineers can review the biggest ones with you.

Related terms

Frequently asked questions

Is Delta Lake free and open source?

Yes. Delta Lake is open source under the Apache 2.0 licence and hosted by the Linux Foundation. You can use it with Apache Spark, Databricks, Microsoft Fabric, Trino, Flink and other engines. Some performance features are specific to commercial platforms, but the table format and transaction log protocol are open.

What is the difference between Delta Lake and Apache Iceberg?

Both are open table formats that add transactions and schemas to files in object storage. Delta Lake is the native format of Databricks and Fabric, while Snowflake, AWS and Google support Iceberg widely. The Databricks UniForm feature lets you read a Delta table as Iceberg too, so you don't always have to choose only one.

What is Delta Lake time travel?

Time travel lets you query a Delta table as it was at an earlier version or timestamp, because the transaction log records every change. Teams use it for audits, reproducing machine learning training data and recovering from bad loads. How far back you can go depends on retention settings and when old files get vacuumed.

Is Delta Lake the same as a data lakehouse?

No. A lakehouse is the overall architecture that combines lake storage with warehouse capabilities. Delta Lake is one of the table formats that make a lakehouse possible, alongside Apache Iceberg and Apache Hudi. A full lakehouse also needs compute engines, a catalog, governance and pipelines around the tables.

Related case study

Case study image showcase

HIPAA Aligned Data Platform on Azure & Databricks

How RUBICON Delivered a Secure, Scalable Foundation for Healthcare Data, Analytics and Machine Learning

More resources

Running Delta tables that have become slow or expensive? Our engineers can review table design and maintenance with you.
Running Delta tables that have become slow or expensive? Our engineers can review table design and maintenance with you.
Running Delta tables that have become slow or expensive? Our engineers can review table design and maintenance with you.