--- title: Delta Lake replaceWhere | daily.dev description: A practical walkthrough of Delta Lake's replaceWhere operation, which allows selective overwrites of a table based on a filter condition instead of rewriting... canonical: https://daily.dev/posts/delta-lake-replacewhere-ouy8zxjh2 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Delta Lake replaceWhere | daily.dev og:description: A practical walkthrough of Delta Lake's replaceWhere operation, which allows selective overwrites of a table based on a filter condition instead of rewriting... og:url: https://daily.dev/posts/delta-lake-replacewhere-ouy8zxjh2 og:image: https://api.daily.dev/og/posts/OUY8zXjh2.png og:image:alt: Delta Lake replaceWhere 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 Lake replaceWhere **[Delta Lake Blog](https://daily.dev/sources/delta-lake)** · 5 min read · 0 upvotes · 0 comments ## Summary A practical walkthrough of Delta Lake's replaceWhere operation, which allows selective overwrites of a table based on a filter condition instead of rewriting the entire dataset. Covers a simple unpartitioned example, a more complex partitioned example (data anonymization by continent), and compares replaceWhere against dynamic partitioning available in Delta Lake 2.0+, recommending replaceWhere for its precision since it forces an explicit filtering predicate. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I overwrite only part of a Delta Lake table without rewriting the whole thing? Use the replaceWhere option with the overwrite save mode to overwrite only rows matching a filter condition, such as number > 2, instead of the entire table. This is more efficient than a full overwrite because it skips rewriting unaffected partitions, saving compute time and cost on large partitioned tables. _Developers optimizing Delta Lake writes can find similar deep dives on daily.dev._ ### What is the difference between replaceWhere and dynamic partition overwrite in Delta Lake? Dynamic partitioning, available in Delta Lake 2.0 and above, overwrites all existing data in every partition touched by new data, while replaceWhere overwrites only rows matching an explicit filter predicate. Dynamic partitioning risks unintentionally wiping an entire partition if a single stray row lands there, so replaceWhere is generally recommended for its precision. _daily.dev helps engineers compare data lake overwrite strategies like these before choosing one._ ### Can replaceWhere update records that span multiple partitions in a Delta table? Yes, replaceWhere can overwrite records across multiple partitions as long as they match the filter condition, such as continent == 'Asia' spanning country partitions like Thailand, Lebanon, and China. The Delta Lake transaction log confirms that only the matching partitions are modified, leaving all others untouched. _daily.dev surfaces practical Delta Lake techniques for engineers tuning partitioned writes._ ## Similar posts on daily.dev - [Modernizing SQL ETL in Lakehouse with Declarative Patterns](https://daily.dev/posts/modernizing-sql-etl-in-lakehouse-with-declarative-patterns-2bcpe5rx0) · databricks · 1 upvotes · 0 comments - [Dynamic Tables Just Got Faster and Far More Flexible — PART 2](https://daily.dev/posts/dynamic-tables-just-got-faster-and-far-more-flexible-part-2-vhlaaaocj) · Snowflake Community · 0 upvotes · 0 comments - [Delta Lake Explained: Boost Data Reliability in Cloud Storage](https://daily.dev/posts/delta-lake-explained-boost-data-reliability-in-cloud-storage-oechbmvm4) · databricks · 0 upvotes · 0 comments --- Tags: [#python](https://daily.dev/tags/python), [#backend](https://daily.dev/tags/backend), [#data-engineering](https://daily.dev/tags/data-engineering), [#apache-spark](https://daily.dev/tags/apache-spark) [View this post on daily.dev](https://daily.dev/posts/delta-lake-replacewhere-ouy8zxjh2) ```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 Lake replaceWhere","url":"https://daily.dev/posts/delta-lake-replacewhere-ouy8zxjh2","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/delta-lake-replacewhere-ouy8zxjh2"},"datePublished":"2026-08-16T08:53:22.364Z","dateModified":"2026-08-16T08:54:39.244Z","description":"A practical walkthrough of Delta Lake's replaceWhere operation, which allows selective overwrites of a table based on a filter condition instead of rewriting...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/122cfb3e2b17a7d5895918718fdc9838?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/122cfb3e2b17a7d5895918718fdc9838?_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-lake-replacewhere-ouy8zxjh2","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"python,backend,data-engineering,apache-spark","timeRequired":"PT5M"} {"@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 Lake replaceWhere"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/delta-lake-replacewhere-ouy8zxjh2#faq","mainEntity":[{"@type":"Question","name":"How do I overwrite only part of a Delta Lake table without rewriting the whole thing?","acceptedAnswer":{"@type":"Answer","text":"Use the replaceWhere option with the overwrite save mode to overwrite only rows matching a filter condition, such as number > 2, instead of the entire table. This is more efficient than a full overwrite because it skips rewriting unaffected partitions, saving compute time and cost on large partitioned tables. Developers optimizing Delta Lake writes can find similar deep dives on daily.dev."}},{"@type":"Question","name":"What is the difference between replaceWhere and dynamic partition overwrite in Delta Lake?","acceptedAnswer":{"@type":"Answer","text":"Dynamic partitioning, available in Delta Lake 2.0 and above, overwrites all existing data in every partition touched by new data, while replaceWhere overwrites only rows matching an explicit filter predicate. Dynamic partitioning risks unintentionally wiping an entire partition if a single stray row lands there, so replaceWhere is generally recommended for its precision. daily.dev helps engineers compare data lake overwrite strategies like these before choosing one."}},{"@type":"Question","name":"Can replaceWhere update records that span multiple partitions in a Delta table?","acceptedAnswer":{"@type":"Answer","text":"Yes, replaceWhere can overwrite records across multiple partitions as long as they match the filter condition, such as continent == 'Asia' spanning country partitions like Thailand, Lebanon, and China. The Delta Lake transaction log confirms that only the matching partitions are modified, leaving all others untouched. daily.dev surfaces practical Delta Lake techniques for engineers tuning partitioned writes."}}]} ```