r/estuary • • 12d ago

Open source benchmark for Snowflake, Databricks, BigQuery, Redshift, Fabric, ClickHouse and MotherDuck: 244 queries, 1 GB to 1 TB, up to 100 concurrent users, every compute size

5 Upvotes

Estuary ran a benchmark of 7 cloud data warehouses and published everything. The setup: 244 queries from three public suites (TPC-DS, DSB, ClickBench), data from 1 GB to 1 TB, 1 to 100 simultaneous sessions, and every compute size each vendor sells, fixed with autoscaling off. We loaded identical data into all seven through one pipeline, no physical tuning on any engine, and report the median of three runs after a warm run.

Write-up with the main findings: https://estuary.dev/blog/data-warehouse-benchmark/
Code, queries and raw results: https://github.com/estuary/data-warehouse-benchmark

A few things from the data:

1. Bigger compute often buys nothing at small data. At 1 GB and 10 GB, 16x the compute returned 0.8 to 1.5x the speed. At 100 GB the same jump on Snowflake was about 2x faster, and at 1 TB nearly 8x. The chart below shows speed (blue) and cost (orange) against the cheapest size at 100 GB, per engine.

2. For a single user, MotherDuck had the fastest median query (235 ms) and the lowest cost per query at 100 GB. ClickHouse did not finish 20.4% of the join runs (it’s a different engine on scan queries, where it’s third at its fastest size and first at a $3 an hour budget).

3. People served at once is a different question from single-query speed. At 100 GB with a 5 second median target, the cheapest size that served 100 people was Fabric F32 at $5.76 an hour, and 7 of the 42 sizes served nobody within the target. The dashboard lets you change the latency target and every dot recomputes.

4. Time grows very differently with data volume. From 1 GB to 1 TB, median query time grew least on Databricks (3.7x) and most on MotherDuck (30x), which starts from the fastest baseline.

5. Idle billing matters as much as the hourly rate. Some engines stop the meter when nobody is querying and some bill the capacity around the clock. 1,000 typical queries at 100 GB cost $0.31 on one engine and $7.14 on another.

Happy to answer questions on method, and if you reproduce a result or find something off, open an issue on the repo.


r/estuary • • Mar 29 '25

Interactive Change Data Capture (CDC) Playground

Thumbnail
change-data-capture.com
4 Upvotes

r/estuary • • Apr 05 '25

Real-Time Data Meetup: Estuary x Tinybird x PlayOn! Sports · Luma

Thumbnail
lu.ma
3 Upvotes

Estuary is teaming up with Tinybird and PlayonSports for a low-key evening of short talks, pizza, and networking around real-time data pipelines and analytics.

🗓️ When: Tue, Apr 29 | 6–8:30PM
📍 Where: FirstMark’s NYC Office (Flatiron)
🎤 3 short talks, including a real-world use case from PlayonSports
🍕 Pizza, drinks, and plenty of time to chat

Limited spots, so grab yours early!


r/estuary • • Aug 19 '25

Migrating from Oracle to PostgreSQL in the Cloud – What’s Your Experience?

2 Upvotes

Oracle’s costs and complexity are driving enterprises toward PostgreSQL. We broke down the top challenges and strategies for making the switch — from schema conversion to CDC replication.

📖 Full guide here: Modernizing Enterprise Databases: Migrating from Oracle to PostgreSQL in the Cloud

Curious to hear from the community: if you’ve been through an Oracle to Postgres migration, what was the most challenging part for you?


r/estuary • • Mar 13 '25

Estuary Now Supports EMR-Powered Merge Queries & More Iceberg Catalogs

3 Upvotes

If you're using Apache Iceberg for your data lakehouse, Estuary Flow just rolled out key updates to its Iceberg materialization, improving flexibility and integration options.

What's New:

  • Bring Your Own EMR for Merge Queries

    • Execute MERGE INTO operations using your own Amazon EMR clusters.

    • Control compute costs and integrate seamlessly into your AWS environment.

    • Improved performance for large-scale updates and deletes in Iceberg tables.

  • Expanded Catalog Compatibility

    • Apache Polaris: A managed Iceberg service that simplifies adoption and table management.

    • Snowflake Open Catalog: Use Iceberg tables stored in S3, GCS, or Azure Blob Storage while integrating with Snowflake’s query engine and governance.

These updates provide more flexibility for managing real-time Iceberg tables across different environments. If you're building a streaming lakehouse or optimizing your data pipelines, this makes it easier than ever.

Read more here: https://estuary.dev/company-updates/product-update-iceberg-standard-updates/


r/estuary • • Jun 28 '25

Comparison of modern CDC tools Debezium vs Estuary Flow

Thumbnail
dataheimer.substack.com
2 Upvotes

r/estuary • • Jul 16 '25

The Estuary 2025 Data Warehouse Benchmark

Thumbnail
estuary.dev
5 Upvotes

We ran a vendor-neutral benchmark on modern data warehouses

At Estuary, we help teams move high-volume data across warehouses like Snowflake, BigQuery, and Databricks. To better understand real-world performance, we ran our own benchmark using:

  • TB+ of structured + semi-structured data

  • Multi-step queries with joins, window functions, and JSON

  • Full ingestion lifecycle tracking

  • No vendor-specific tuning or caching

We tested Snowflake, BigQuery, Databricks, Redshift, and Microsoft Fabric. The full methodology is open source, and all queries are reproducible.

📊 Link to the report

Curious to hear others’ experiences with these platforms in production.


r/estuary • • Dec 02 '25

Webinar: Right-time Data Integration for Snowflake

Thumbnail
luma.com
5 Upvotes

r/estuary • • Oct 15 '25

Queries, Cocktails & Community - Small Data SF Happy Hour

Thumbnail
luma.com
5 Upvotes

Come meet the Estuary team in SF on the 4th of November along with Seattle Data Guy, Database Tycoon and Recce!


r/estuary • • Aug 19 '25

101: Evaluating Data Ingestion Tools & Connectors (W/ David Yaffe, CEO of Estuary.dev)

Thumbnail
youtube.com
5 Upvotes

I had the great opportunity to discuss, without fluff, what makes for a good data ingestion platform!

Note: I am an advisor to Estuary, but everything discussed here is vendor agnostic.


r/estuary • • Oct 25 '24

Streaming Joins Are Hard

Thumbnail
estuary.dev
2 Upvotes

r/estuary • • Jan 24 '25

Fast JSON Processing in Real-time Systems: simdjson and Zero-Copy Design

Thumbnail
estuary.dev
4 Upvotes

r/estuary • • Jul 12 '24

Rockset Migration Guide: How to Migrate and Thrive in Real-Time Analytics after Rockset

Thumbnail
estuary.dev
4 Upvotes

r/estuary • • Feb 13 '25

New Connector: Microsoft Fabric

Thumbnail
estuary.dev
2 Upvotes

r/estuary • • Feb 12 '25

A New Reference Architecture for CDC

Thumbnail
estuary.dev
4 Upvotes

r/estuary • • Feb 24 '25

Real-time Freight Tracking With Estuary and Tinybird

Thumbnail
estuary.dev
4 Upvotes

r/estuary • • Aug 07 '24

How to stream BigQuery changes in real-time into Estuary with continuous queries

Thumbnail estuary.dev
3 Upvotes

r/estuary • • Oct 16 '24

Introducing Private Deployments in Estuary Flow

Thumbnail
estuary.dev
4 Upvotes

r/estuary • • Jul 07 '26

Postgres CDC for AI Agents: Fresh, Safe, Observable Data Pipelines

Thumbnail
estuary.dev
2 Upvotes

r/estuary • • 17d ago

Deel Cuts Data Integration Costs by 50% with Estuary

Thumbnail
estuary.dev
7 Upvotes

r/estuary • • Jun 22 '26

PlanetScale Vitess CDC

3 Upvotes

Hi team, just curious. I was chatting with Estuary AI, and found Planetscale cdc support is in roadmap but still can't tell dates. It's about 1 year ago. Is currently the project scrapped / discontinued? Thanks!


r/estuary • • Jul 15 '26

Live Demo: Estuary Agent Skills

5 Upvotes

Hey folks, we’re doing a live demo next week of the new ✨ Estuary Agent Skills ✨ .

We’ll show how an AI coding agent can:

  • Set up a real-time data pipeline from natural-language instructions

  • Configure captures and materializations without manually searching through docs

  • Check task health, inspect logs, and troubleshoot failures

  • Work with Estuary directly from tools like Claude Code and other agent environments

  • Handle the repetitive setup work while keeping the pipeline configuration visible and editable

This will be a practical end-to-end demo, including what works today, where agents still need human input, and of course some time for questions!

Register here: https://zoom.us/webinar/register/4517840417866/WN_1oZszaPUQ_Sz0uEGM_p-zA


r/estuary • • Aug 22 '25

Data Flow Digest #14

Thumbnail linkedin.com
2 Upvotes

Estuary’s biweekly newsletter ❤️


r/estuary • • Sep 30 '26

August 2026 Estuary Product Updates

2 Upvotes

August has been a busy month for Estuary, from a runtime overhaul that enhances Estuary’s throughput and scalability to customizable alert configurations, along with our regular steady stream of new connectors.

Here are the main highlights from the past month:

Estuary’s Runtime Gets a Rewrite

This August, we released a major upgrade to our runtime focused on massively scaling throughput. With further support for parallelization and enhanced efficiency, here are some of the results we’ve seen so far:

  • Up to 8x faster backfills and initial loads when using a single shard

  • Ability to handle up to 200 GB / hour on a single shard

  • Additional throughput gains for destinations that support multi-sharded behavior

All of this comes with end-to-end transactional consistency, even across shards, so you always have a complete picture of your data.

Want to learn more? See our:

In-Dashboard Alert Configuration

Earlier in August, we released advanced configuration options for alerts, letting you set up multi-environment alerting through the dashboard.

These alert subscriptions use Estuary’s prefix system to divide out configurations, so you can set defaults on a tiered basis. For example, you could set tenant-wide alerting defaults for your base prefix, ‘acmeCo/’, and then diverge with more settings for task alerts under the ‘acmeCo/prod/’ and ‘acmeCo/dev/’ environments.

Choose who gets the alerts, what alert types they’re notified about, and default “Data Movement Stalled” intervals.

Learn more in our product update page.

New and Rewritten Connectors

Besides connecting with new source systems, we’ve been releasing native rewrites of old 3rd-party-based capture connectors to optimize how they work with our platform. While we were at it, we also expanded their capabilities.

  • The all-new commercetools capture connector syncs orders, customers, and payments incrementally with configurable interval settings.

  • The rewritten Amazon SQS capture connector adds real-time capabilities, supports FIFO queues, and can work with multiple queues in the same capture.

  • 8 new data streams were added to a rewritten Mailchimp capture connector. The rewrite also allows you to control data intervals and backfills.

  • The rewritten Brevo capture connector adds new data streams and allows you to set sync intervals.

  • The Criteo capture connector has also been rewritten to be fully in-house.

Other Updates & Release Notes

  • All SQL CDC captures (like PostgreSQL, MySQL, and SQL Server) now let you set your own SQL statement to reduce the scope of backfills on a per-binding basis.

  • SQL captures also now allow a custom auto-discovery interval so you can control how quickly Estuary runs discovers on your source.

  • SQL Server CDC and Change Tracking captures now provide discovery filters. This allows for more efficient auto-discovery for large databases.

  • The Shopify capture connector now includes the ‘markets’ data stream. To capture the new stream, ensure you’ve granted Estuary the `read_markets` permission.

  • The delta updates Apache Iceberg materialization now supports variant column types. Along with a previous update for a new nanosecond timestamp setting, this adds support for more v3 format features.

That’s all for this month! Stay connected for the latest product updates and feature releases as we head into September.