--- title: Delta Grows Up: Writes, Unity Catalog and Time Travel description: DuckDB's Delta and Unity Catalog extensions have graduated from experimental status, adding INSERT write support, time travel queries pinned to specific Delta... canonical: https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Delta Grows Up: Writes, Unity Catalog and Time Travel | daily.dev og:description: DuckDB's Delta and Unity Catalog extensions have graduated from experimental status, adding INSERT write support, time travel queries pinned to specific Delta... og:url: https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs og:image: https://api.daily.dev/og/posts/vhUXiUAXS.png og:image:alt: Delta Grows Up: Writes, Unity Catalog and Time Travel og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Delta Grows Up: Writes, Unity Catalog and Time Travel **[Delta Lake Blog](https://daily.dev/sources/delta-lake)** · 9 min read · 0 upvotes · 0 comments ## Summary DuckDB's Delta and Unity Catalog extensions have graduated from experimental status, adding INSERT write support, time travel queries pinned to specific Delta table versions, and full Unity Catalog integration for both OSS and Databricks implementations. Catalog Managed Tables now support Catalog Commits, letting Unity Catalog arbitrate concurrent writes across multiple DuckDB writers so exactly one commit lands per version while others receive conflict errors to retry. Snapshot loading also gets incremental loading in nightly builds, speeding up time travel across nearby versions ahead of the v1.5.3 stable release. UPDATE, DELETE, MERGE, and CREATE TABLE DDL remain unsupported but are planned. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### Does DuckDB support writing (INSERT) into Delta Lake tables? Yes, DuckDB's Delta extension now supports INSERT statements into Delta tables as of its graduation from experimental status. Multiple INSERTs within a single BEGIN/COMMIT block are stored as one atomic Delta version. UPDATE, MERGE, and DELETE are not yet supported but are planned for future work. _Track DuckDB's evolving Delta Lake write capabilities on daily.dev before planning a lakehouse migration._ ### How does Unity Catalog handle conflicting concurrent writes to a Delta table from DuckDB? Unity Catalog's Catalog Commits feature arbitrates concurrent writes by staging each commit and registering it with Unity Catalog before it becomes visible, ensuring exactly one commit lands per version while other writers receive a conflict error and can retry. In a test with 20 concurrent DuckDB writers, 5 writes succeeded and 15 received conflicts, resulting in 35 total rows from 10 seeded plus 5 successful batches of 5. _Developers coordinating multi-writer data pipelines can follow catalog-commit patterns like this on daily.dev._ ### How do I enable Catalog Managed Tables and Catalog Commits for a Delta table in Unity Catalog? Set the delta.feature.catalogManaged table property at creation time, which must be done via Spark or the Unity Catalog CLI since DuckDB's Unity Catalog extension does not yet support CREATE TABLE DDL. Once enabled, DuckDB writes automatically go through Unity Catalog's commit staging directory, with the INSERT syntax unchanged. _Anyone setting up governed lakehouse writes can keep up with DuckDB and Unity Catalog changes on daily.dev._ ## Similar posts on daily.dev - [Delta Grows Up: Writes, Unity Catalog and Time Travel](https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-j5aia1x3q) · DuckDB · 0 upvotes · 0 comments - [Delta Lake \+ DuckDB. Catalog Commits with Unity Catalog. Unlocking Concurrent Ingestion.](https://daily.dev/posts/delta-lake-duckdb-catalog-commits-with-unity-catalog-unlocking-concurrent-ingestion--nfihjjzf9) · Confessions of a Data Guy · 0 upvotes · 0 comments - [Introducing the UC Delta API](https://daily.dev/posts/introducing-the-uc-delta-api-phw3nzgrc) · Delta Lake Blog · 0 upvotes · 0 comments - [How Unity Catalog managed tables bring interoperability, performance, and unified governance to the Lakehouse](https://daily.dev/posts/how-unity-catalog-managed-tables-bring-interoperability-performance-and-unified-governance-to-the--8wtwlazxm) · databricks · 0 upvotes · 0 comments - [The Convergence of Open Table Formats and Open Catalogs: Catalog Commits is Generally Available](https://daily.dev/posts/the-convergence-of-open-table-formats-and-open-catalogs-catalog-commits-is-generally-available-smdzq51ud) · databricks · 0 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#data-engineering](https://daily.dev/tags/data-engineering), [#duckdb](https://daily.dev/tags/duckdb), [#unity-catalog](https://daily.dev/tags/unity-catalog) [View this post on daily.dev](https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Delta Grows Up: Writes, Unity Catalog and Time Travel","url":"https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs"},"datePublished":"2026-08-16T08:53:33.033Z","dateModified":"2026-08-16T08:55:33.620Z","description":"DuckDB's Delta and Unity Catalog extensions have graduated from experimental status, adding INSERT write support, time travel queries pinned to specific Delta...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/86fc209a1821c3a7b07c5311e043c8d7?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/86fc209a1821c3a7b07c5311e043c8d7?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Delta Lake Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Delta Lake Blog","logo":"https://media.daily.dev/image/upload/s--7f2q9Asf--/f_auto,q_auto/v1786870393/logos/delta-lake?_a=BAMAMicg0","url":"https://daily.dev/sources/delta-lake"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,data-engineering,duckdb,unity-catalog","timeRequired":"PT9M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Delta Lake Blog","item":"https://daily.dev/sources/delta-lake"},{"@type":"ListItem","position":3,"name":"Delta Grows Up: Writes, Unity Catalog and Time Travel"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/delta-grows-up-writes-unity-catalog-and-time-travel-vhuxiuaxs#faq","mainEntity":[{"@type":"Question","name":"Does DuckDB support writing (INSERT) into Delta Lake tables?","acceptedAnswer":{"@type":"Answer","text":"Yes, DuckDB's Delta extension now supports INSERT statements into Delta tables as of its graduation from experimental status. Multiple INSERTs within a single BEGIN/COMMIT block are stored as one atomic Delta version. UPDATE, MERGE, and DELETE are not yet supported but are planned for future work. Track DuckDB's evolving Delta Lake write capabilities on daily.dev before planning a lakehouse migration."}},{"@type":"Question","name":"How does Unity Catalog handle conflicting concurrent writes to a Delta table from DuckDB?","acceptedAnswer":{"@type":"Answer","text":"Unity Catalog's Catalog Commits feature arbitrates concurrent writes by staging each commit and registering it with Unity Catalog before it becomes visible, ensuring exactly one commit lands per version while other writers receive a conflict error and can retry. In a test with 20 concurrent DuckDB writers, 5 writes succeeded and 15 received conflicts, resulting in 35 total rows from 10 seeded plus 5 successful batches of 5. Developers coordinating multi-writer data pipelines can follow catalog-commit patterns like this on daily.dev."}},{"@type":"Question","name":"How do I enable Catalog Managed Tables and Catalog Commits for a Delta table in Unity Catalog?","acceptedAnswer":{"@type":"Answer","text":"Set the delta.feature.catalogManaged table property at creation time, which must be done via Spark or the Unity Catalog CLI since DuckDB's Unity Catalog extension does not yet support CREATE TABLE DDL. Once enabled, DuckDB writes automatically go through Unity Catalog's commit staging directory, with the INSERT syntax unchanged. Anyone setting up governed lakehouse writes can keep up with DuckDB and Unity Catalog changes on daily.dev."}}]} ```