Skip to content
All topics

Delta Lake

Recent items mentioning Delta Lake across the Databricks ecosystem — releases, news, videos, and community Q&A. Updated hourly.

60 recent items18 releases14 news8 videos20 community threads

What is Delta Lake?

Delta Lake is the storage layer that provides the foundation for tables on Databricks. It's open source software that extends ordinary Parquet data files with a file-based transaction log, which turns a directory of files in cloud storage into a real table with ACID transactions and dependable metadata handling. It works with Apache Spark APIs and Structured Streaming, so batch and streaming jobs read and write the same tables.

The transaction log is what makes a lakehouse workable. It gives you schema enforcement on write, time travel for querying earlier versions of a table, a change data feed for tracking row-level changes, and safe concurrent reads and writes, none of which plain Parquet directories can do. Features like liquid clustering and data skipping simplify data layout and speed up queries.

On Databricks it's simply the default: unless you specify otherwise, every table you create is a Delta table. It also plays well outside its own ecosystem. With Iceberg reads enabled, UniForm generates Iceberg metadata alongside the Delta log without rewriting data files, so a single copy of the data serves both Delta and Iceberg clients.

Do I need to do anything to use Delta Lake on Databricks?

No. Delta Lake is the default format for all operations on Databricks, and unless otherwise specified, all tables you create are Delta tables.

How is Delta Lake different from plain Parquet?

Delta tables store their data as Parquet files but add a file-based transaction log next to them. The log is what enables ACID transactions, schema enforcement, and time travel to previous table versions; a plain Parquet directory is just files with none of those guarantees.

Delta Lake vs Apache Iceberg: do I have to choose?

Not for reads. Both formats are Parquet data files plus a metadata layer, and enabling Iceberg reads makes UniForm generate Iceberg metadata alongside the Delta metadata, so one copy of the data serves both kinds of clients. Iceberg client support is read-only; writes aren't supported.

Does Delta Lake cost anything?

The format itself is open source software, so there's no license cost. On Databricks it's built in as the default table format rather than a separately priced product.

Sources: What is Delta Lake? (Databricks docs) · Read Delta tables with Iceberg clients, UniForm (Databricks docs)

What's happening in Delta LakeAI synthesis · updated 1d ago

Multi-statement transactions reached general availability for both Delta Lake and Apache Iceberg tables on Databricks, bringing atomic multi-table guarantees backed by row-level concurrency and Unity Catalog governance 5. Delta Lake 4.4.1 followed with safeguards for catalog-managed tables, blocking unsupported cleanups and skipping automatic maintenance so writes succeed, plus a fix for snapshot errors from unratified staged commits that lets S3A fast listing be safely re-enabled 6. Around the core, Databricks Free Edition now anchors a full data and AI curriculum on Delta Lake and Spark 4, while MiniLake offers a local Databricks API emulator with SQL, Delta Lake and Spark 3.

Generated daily from the 6 most recent items mentioning Delta Lake. Click any [N] to jump to the source.

Databricks CommunityCommunity Articles

Building an AI Search Visibility Tracker With Databricks, Delta Lake, and Python

00yesterday
Databricks CommunityData Engineeringanswered

Best practices and optimization tips for Delta Lake tables

002d ago
HackerNews

MiniLake Is a Local Databricks API Emulator with SQL, Delta Lake and Spark

--- top comments --- [gavinray] If this actually works, this is such a huge boon. Let me share why: I work on connectors to various datasources, mostly SQL DB's The most useful tests are the integration tests, sending actual queries to the source For most DB's we have a giant Docker Compose which runs a local instance But things like Snowflake, Databricks, Redshift, Athena suck to test because we need an external hosted instance I would kill to be able to run test versions of all of these locally [akbarian] Getting tired of the standard AI design, all websites look the same now [ngruhn] You should call it "pond". [lysecret] Want to hijack this someone made experience recently with https://ducklake.select/ ? We need to setup a warehouse soon and this looks enticing. [asabla] Oh wow! This would've been so useful at my previous work place. I'll save this one for later. Looks pretty decent too for homelabs! I wonder if there is any plans on extending it further? (just a bit)

9625kermatt3d ago
Reddit

Optimize Delta Lake Write Performance With spark.databricks.delta.optimizeWrite.enabled

Hey, I work as a Databricks Engineer, so here's my take. Small file problems destroy read performance in Delta tables. If your streaming pipelines or frequent batch inserts generate thousands of tiny parquet files, enable spark.databricks.delta.optimizeWrite.enabled at the session or table level. When set to true, Databricks automatically coalesces data right before writing, targeting roughly 512MB per file. This happens dynamically within the shuffle stage, reducing the need for post-hoc OPTIMIZE commands. Pair this with spark.databricks.delta.autoCompact.enabled to automatically compact small files in partitions after writes complete. You will trade a fraction of driver memory and shuffle time for significantly cleaner storage layouts, faster merge operations, and much lower cloud storage list-request costs during downstream reads. For anything else on Databricks | Platform Engineering | AI , visit Abilytics — AI Systems, Data Engineering & Platform Engineering Services. submitted by /u/AbilyticsEng [link] [comments]

00AbilyticsEng3w ago
Reddit

Databricks Micro Apps, App Spaces and Genie App Generator

Databricks launched App Spaces and Serverless Micro Apps at the end of last week (in Beta). Over the weekend, I tested migrating two of my production Databricks Apps to App Spaces. App Migration 1: Blocked by Zero Egress My Data Portfolio Project Creator required internet access to pull data stacks from live job postings. Then, the LLM needs internet access to research for open data sources to use. In standard Databricks Apps, this runs cleanly. In App Spaces, there is zero external internet egress including for LLMs. The app can reach internal workspace resources, but it cannot touch the outside web. If your app relies on third-party APIs, external databases, or web scraping, App Spaces is a non-starter until Databricks opens network egress. Workload 2: Success on Internal FinOps My client-facing DBU cost observability app reads workspace usage data and writes directly to Lakebase. Because it requires zero external network calls, the migration worked. Both the micro app compute and Lakebase scale to zero when idle. Cold starts take roughly 30 seconds (though in beta, you occasionally need a quick browser refresh once it spins up). For internal, low-frequency administrative tools, this turns a continuous monthly compute bill into pennies. (+ App Spaces, Genie App Generator, and Micro Apps are free while in beta) The next part is less about App Spaces and more just general best practice for Databricks Apps that I see people miss. Stop Using Delta Lake as an OLTP Database Databricks Apps are software applications, not batch analytics notebooks. If your app writes application state, session data, or row-level CRUD directly into analytical Delta tables, you need to rethink that design. For app transactions, use Lakebase (serverless Postgres which also scales to 0). Both are governed under UC, but Lakebase gives your app the low-latency transactional engine that application engineering actually requires. My Verdict on the Beta App Spaces solves the idle compute problem that has plagued Databricks Apps since launch. But until Databricks allows us to deploy directly from existing Git repos and opens external network egress, it remains limited to internal-only use cases. Curious on other peoples experience... How has it been for others? submitted by /u/OkImprovement7010 [link] [comments]

00OkImprovement70101mo ago
Reddit

Which Came First For You... Spark or Databricks?

Saw a post this morning claiming you shouldn't touch Databricks until you've already mastered Apache Spark. That advice is backwards. It treats learning like a 90s waterfall project and traps engineers in tutorial hell. The fundamentals are non-negotiable: - You need SQL and Python. - You need to understand distributed shuffles, partitions, and memory spills. - You need to understand Parquet structures, metadata footers, and row groups. - You need to understand Delta Lake transaction logs and ACID guarantees. If you don't know what happens under the hood, you will write brittle pipelines that burn cloud budgets. The false assumption is that you must learn these concepts in an abstract vacuum before touching a modern platform. You don't learn networking by memorizing RFC packet headers on a whiteboard for six months before opening Wireshark. You fire up the tool, capture packets, and inspect the traffic. Databricks, Fabric, or Snowflake is your network analyzer. It is the laboratory. Nobody in enterprise production is setting up bare-metal Spark clusters on a home lab just to learn how shuffles work. And running local[*] on a laptop masks real-world distributed realities: - Local filesystems use POSIX atomic renames. Cloud object stores (S3, ADLS) do not. You cannot truly grasp why Delta's _delta_log exists until you see it write commits against cloud storage. - A local JVM masks network serialization, executor skew, and cross-node shuffle overhead. The caveat: don't treat the platform as a black box. Don't just click "Run All" on serverless compute and assume you know Spark. Use the platform to inspect the engine: - Run .explain(True) and read the physical plan. - Open the Spark UI to watch tasks, stages, and memory spill. - Inspect the JSON commits inside _delta_log after a merge operation. - Compact small files and see how file pruning changes scan times. You don't master the theory first and then graduate to a platform. You master the fundamentals by using the platform as your workbench. Learn the platform. Learn the engine. Learn the storage layer. Do it concurrently, in the environment where production actually lives. submitted by /u/OkImprovement7010 [link] [comments]

00OkImprovement70101mo ago
Databricks CommunityCommunity Articles

Deletion Vectors Don’t Delete Data the Way You Think They Do: A Deep Dive into Delta Lake Maintenanc

001mo ago
Databricks CommunityGenie Hub

Getting started with Delta Lake basics

001mo ago
Reddit

Azure AI Foundry + Databricks Architecture | Deploy Genie Agent with DAB...

Azure AI Foundry Databricks architecture, Deploy Genie Agent with DABs, Databricks Genie Agent, Azure Databricks Genie Space, how to deploy genie agent with declarative automation bundles, azure ai foundry + databricks integration, fully operating genie architecture databricks, databricks unity catalog genie agent, azure databricks bronze silver gold architecture, agent to agent nlq databricks, databricks spark python sql delta lake unity catalog, production ready genie agent deployment, databricks vector search index genie, microsoft purview databricks governance submitted by /u/macxima [link] [comments]

00macxima1mo ago
Reddit

What Data Engineers Need To Know About Delta Lake 4.3

replaceUsing and replaceOn give you a better overwrite primitive, and every catalog-managed table operation now runs through the catalog. submitted by /u/Lenkz [link] [comments]

00Lenkz1mo ago
Reddit

Automatic change data feed is now generally available!

With automatic CDF, Databricks computes row-level changes at read time using row tracking, rather than materializing those changes during every write. Use change data feed on Databricks | Databricks on AWS Why does that mattre? - Better write performance for MERGE INTO and UPDATE workloads - No need to enable CDF individually on every eligible table - Lower storage overhead compared with legacy CDF - The same familiar APIs still work: table_changes() and readChangeFeed - Works with batch processing, Structured Streaming, and Databricks-to-Databricks Delta Sharing For Delta Lake, the main requirements include: • Databricks Runtime 19 LTS+ • A managed table or external table in Delta Lake format with row tracking enabled And if you’re already using legacy CDF, migration is really simple.Once the table meets the requirements, disable legacy CDF: https://preview.redd.it/0dddizd442oh1.png?width=710&format=png&auto=webp&s=fddc536d6aeca423b2e418f4856ae06843393749 submitted by /u/szymon_dybczak [link] [comments]

00szymon_dybczak1mo ago
Databricks CommunityData Engineering

What is a Data Skipping in Delta Lake?

001mo ago
Reddit

Iceberg vs Deltalake (greenfield project with UC in 2026)

I saw the quarterly meeting and was quite shocked that Iceberg is prominently mentioned, (as much as Deltalake). Is it possible that both are getting the same amount of love from Databricks? Is anyone aware of the R&D effort on these formats, and can share conclusions from that? If I'm building a greenfield Unity Catalog, should I just flip a coin to decide what format to use? Here are the main concerns and priorities: Which one is better for OSS Apache Spark reads and writes Which one integrates with external software better (eg onelake shortcuts pointing from Fabric to Databricks UC). When Databricks is innovating within their own UC (eg. introducing new managed table functionality such as "MST Transactions"), which one of these formats are they likely to support first? Which are they likely to optimize better? Which format is more likely to remain 100% open source in the future (or as close to open source as required by customers who want portable blob data). Sorry if this appears to be a common question. I am a Databricks outsider. I am more familiar with Microsoft Fabric. Where that Fabric SaaS is concerned, you can be certain that Deltalake receives a LOT more promotion than Iceberg does. We rarely come across Iceberg, and it probably wouldn't appear in any marketing slide decks. We are likely to create a gold/presentation layer in UC soon. It will basically be created from scratch. It would be nice to know which of these parquet-based formats to pick, when presented with the choice. I understand there is lip-service given to both, and it claims that this choice "doesn't matter". But that doesn't necessarily take into account the potential integrations that are needed with external software (eg. for the benefit of exposing the same tables in onelake). Is one safer than the other? Is one of them a better choice for forward-looking purposes? submitted by /u/SmallAd3697 [link] [comments]

00SmallAd36972mo ago
Reddit

Databricks zerobus vs Fabric open mirroring (2026)

Has anyone seen any comparison between the generalized ingestion mechanism (zerobus) with Fabric's offering (open mirroring)? Seems like there should be a blog or youtube video comparing the two by now. But I haven't seen any. Unfortunately it sounds like they both rely on proprietary middleware. Ideally there would be a similar type of software which that we could just run on-premise to land data into cloud blobs (like a gateway of some kind). Not sure why that would be so hard for someone to do as a github library or something. Maybe it would need to be done in a performant language like rust or .net, but it doesn't seem like it would be rocket science. Both those technologies are relatively recent: Fabric open mirroring : May 2025 Zerobus : Feb 2026 Personally I wouldn't want to pick either one of these technologies until a comparison could be made. Microsoft's open mirroring claims that they can land data in their lakehouses for free. After that point, the raw deltalake tables would be accessible to both platforms. If open mirroring is truly free then it seems odd that any databricks customers would be using zerobus. They should just purchase the smallest possible capacity from Microsoft like an F2, and use that for moving all their data to raw/bronze in adls gen2 containers. Whatever happens after that can take place in either of these two saas'es, databricks or fabric. submitted by /u/SmallAd3697 [link] [comments]

00SmallAd36972mo ago
Reddit

Minilake: a free, local Databricks API emulator — a single-developer tool for testing databricks-sdk/Terraform code against real SQL, real Delta Lake, and real Job execution

submitted by /u/agentdero [link] [comments]

00agentdero2mo ago
Databricks CommunityCommunity Articles

🇪🇸 ☕ ¿Cómo organiza Databricks tus datos? | De Unity Catalog a Delta Lake ⚡

002mo ago
Databricks CommunityCommunity Articles

Your Delta Lake Table Is Secretly Ballooning — Here's the 2-Command Fix

005mo ago
Databricks CommunityCommunity Articles

From 400GB to 35GB: Managing Delta Lake Storage Growth

005mo ago
RedditDiscussion

Enzyme whitepaper - incremental view maintenance

I know this is pretty nerdy stuff, but I found this paper super interesting: "**Enzyme: Incremental View Maintenance for Data Engineering"**. [Enzyme: Incremental View Maintenance for Data Engineering](https://arxiv.org/html/2603.27775v2) IVM (incremental view maintenace) is not a brand-new problem. It has been studied in databases for decades. The basic idea is - when source data changes, Enzyme tries to avoid rerunning the entire query from scratch. Instead, it figures out which parts of the existing result are affected and updates just those parts, while still producing the same result you’d get from a full recompute. What I found especially interesting is how much “under the hood” machinery is needed to make this work reliably: * tracking source table changes with Delta Lake features like Change Data Feed, row tracking, deletion vectors, and time travel * decomposing queries into logical operators like filters, joins, aggregations, and windows * generating delta plans for each operator * deciding whether incremental refresh is actually cheaper than full recompute * handling non-deterministic functions, Python UDFs, query fingerprints, and pipeline dependencies * falling back safely when incrementalization is not worth it or not safe Also, I wasn't aware that a materialized view is not just “the final table.” Under the hood it consists of two parts: 1. backing table - which stores the user’s data plus internal metadata columns 2. top-level view - which describes how the result should be computed, The split architecture of MVs at Databricks, comprising a backing Delta table and a top-level view, provides flexibility for incremental computation. For example, if the top-level view contains AVG(x), Enzyme can internally store SUM(x) and COUNT(\*), because those are easier to update incrementally when new rows arrive. Databricks says Enzyme was validated across thousands of production pipelines and produced cumulative daily compute savings of billions of CPU seconds. On the TPC-DI benchmark, it incrementalized 100% of the workloads and beat full recomputation in 6 out of 8 datasets.

276szymon_dybczak5mo ago
RedditGeneral

PipelineIQ: Forward‑Looking Sales Intelligence That Drives Action

Your CRM data is a mess. Everyone knows it. Most AI tools pretend it isn't. Databricks took a different approach with PipelineIQ - instead of building yet another forecasting model that assumes clean data (spoiler: it never is), they built a prescriptive action engine that works with the chaos. The result? Every deal in the pipeline gets one of three verdicts: 🚶 Walk - disengage, this isn't worth your time 🔄 Pivot - viable deal, wrong approach 🚀 Accelerate - conditions are right, lean in now No vague "insights." No dashboards that require a PhD to interpret. Just: here's what to do today. Built on Databricks' own stack (Foundation Model APIs, Delta Lake, Unity Catalog) and used internally by their own sales org - this is a rare "we built it for ourselves first" story. Read the full blog here: [https://www.databricks.com/blog/pipelineiq-forward-looking-sales-intelligence-drives-action](https://www.databricks.com/blog/pipelineiq-forward-looking-sales-intelligence-drives-action)

00sai-nageshwaran5mo ago