> Markdown version of [/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client?t=145](https://www.wearedevelopers.com/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client?t=145). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client

Imagine migrating a 620TB active data warehouse without a single maintenance window. See how a custom proxy transpiles SQL mid-flight to swap compute engines invisibly beneath millions of queries.

- **Speakers:** [Max Fischer](https://www.wearedevelopers.com/@max-fischer), [Michael O'Toole](https://www.wearedevelopers.com/@michael-o-toole)
- **Event:** World Congress 2026 Europe
- **Published:** July 10, 2026
- **Duration:** 30:28
- **URL:** https://www.wearedevelopers.com/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client
- **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/51607ae223ac28c9f25cee81ce3eb393/thumbnails/thumbnail.jpg?time=82789ms

## Access

Playback and chapters for this video are available with a Free account.

## Related Moments

- [Summary of decoupling analytical compute and storage](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) (from "Parquet, Delta, Iceberg & Ducklake - An introduction for developers")
  - **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/04c7705ac1bd97a60549c8aee29134b2/thumbnails/thumbnail.jpg?time=58280ms
- [Boosting developer productivity via consolidated converged database architectures](https://www.wearedevelopers.com/videos/632-crypto-secure-data-management-with-in-database-blockchain) (from "Crypto-secure Data Management with In-Database Blockchain")
  - **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/77a0ebb210e971124c645bfb131dba16/thumbnails/thumbnail.jpg?time=283085ms
- [Solving complex platform architecture challenges at an enterprise scale](https://www.wearedevelopers.com/videos/1209-coffee-with-developers-maria-apazoglou) (from "Coffee with Developers - Maria Apazoglou")
  - **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/d4928410513d721bb27c5df3dc5be0a5/thumbnails/thumbnail.jpg?time=185545ms
- [Executing massive cloud network migrations while maintaining live systems](https://www.wearedevelopers.com/videos/100128-the-golden-age-of-email-owning-the-inbox-in-the-age-of-ai) (from "The Golden Age of Email: Owning the Inbox in the Age of AI")
  - **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/70935784deb62adbe0d0144696958b7d/thumbnails/thumbnail.jpg?time=43830ms
- [Modernizing queries using microservices and federated schemas](https://www.wearedevelopers.com/videos/983-reliable-scalability-how-amazon-com-scales-on-aws) (from "Reliable scalability: How Amazon.com scales on AWS")
  - **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/2977b382943ec1ced637655f0595a685/thumbnails/thumbnail.jpg?time=112625ms
- [Designing data ingestion architecture with system integration](https://www.wearedevelopers.com/videos/688-implementing-an-event-sourcing-strategy-on-azure) (from "Implementing an Event Sourcing strategy on Azure")
  - **Thumbnail URL:** https://customer-goifxnzhrq3d0d54.cloudflarestream.com/b0edbdc9e21ab856c53979dbf5690f7b/thumbnails/thumbnail.jpg?time=137400ms

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Why Event-Driven Architecture Isn’t About Speed (and When You Actually Need It)](https://www.wearedevelopers.com/magazine/745-why-event-driven-architecture-isn-t-about-speed-and-when-you-actually-need-it)
- [A Tour of the PostgreSQL Analytics Ecosystem](https://www.wearedevelopers.com/magazine/792-a-tour-of-the-postgresql-analytics-ecosystem)

## Related Jobs

- [Director of Engineering - Data Platform SDM5](https://www.wearedevelopers.com/jobs/48598-director-of-engineering-data-platform-sdm5) at **WEX**
- [Software Development Engineer 5](https://www.wearedevelopers.com/jobs/48599-software-development-engineer-5) at **WEX**
- [Senior Data & AI Architect](https://www.wearedevelopers.com/jobs/48602-senior-data-ai-architect) at **reeeliance IM GmbH**
- [Senior Software Engineer - Semantic Data Lake (Open)SDE3](https://www.wearedevelopers.com/jobs/48597-senior-software-engineer-semantic-data-lake-open-sde3) at **WEX**
- [Lead Software Engineer - Data Engineering](https://www.wearedevelopers.com/jobs/ext/2000968-lead-software-engineer-data-engineering) at **Dynatrace**
- [Principal Systems Engineer, Database Infrastructure](https://www.wearedevelopers.com/jobs/ext/3938825-principal-systems-engineer-database-infrastructure) at **GitHub**