You asked, We Listened: Sharing, UI and Performance Improvements

2024/10/22 - 2 min read

BY

Hello all - this is Doug, the new Head of Produck at MotherDuck.

In my first blog post, I’m writing to tell you about some recent improvements we’ve made that might not be huge on their own, but collectively make our product better. MotherDuck is constantly improving as a data warehouse - in this post, I’ll briefly introduce recently-launched features that make exploring large data sets, querying, and data sharing more efficient and intuitive.

Preview cell contents UI

Working with complex data types, such as JSON or nested structures, can be cumbersome. Often, the values are too large to fit within a single cell, making it difficult to see the complete picture.

With the new cell preview UI, you can view the full contents of selected cells, allowing you to inspect large or complex data types—like STRUCTs, ARRAYS, MAPS, or even BLOBs—in full detail.

Preview Animated GIF

Dual Execution performance optimizations

With Dual Execution, MotherDuck lets you analyze this local data locally, while still JOINing with data processed in the cloud, giving you efficient use of all your compute resources and allowing you to query local data in milliseconds.

We’ve made optimizations to reduce the round trips needed for many Dual Execution queries from two to one. This will result in many users will see significant improvements in response times, which will range from 10s to 100s of milliseconds, depending on your proximity to the data center you are querying.

Auto Update Shares

With the introduction of Auto Update, you can now set your database shares to automatically sync with the latest changes—both DDL and DML—within five minutes of any completed writes.

Previously, when sharing a database, the snapshot you shared remained static until you explicitly updated it by running the UPDATE SHARE statement. Now, users can automate updates by setting the UPDATE AUTOMATIC option during share creation.

What's next?

I’m excited to get to know the MotherDuck community. What would you like to see next? Reach out in the #feature_request channel in our MotherDuck Community Slack!

CONTENT
  1. Preview cell contents UI
  2. Dual Execution performance optimizations
  3. Auto Update Shares
  4. What's next?

Start using MotherDuck now!

blog subscription icon

Subscribe to motherduck blog

PREVIOUS POSTS

Union and MotherDuck's Orchestrated Approach to Advanced Analytics

2024/10/18 - Daniel Sola

Union and MotherDuck's Orchestrated Approach to Advanced Analytics

Leverage MotherDuck & Union to orchestrate advanced analytics flows, AI & LLMs

Small Data is bigger (and hotter 🔥) than ever

2024/10/19 - Sheila Sitaram

Small Data is bigger (and hotter 🔥) than ever

Catch up on the latest developments around simple, scalable workflows for Real data volumes from the first Small Data SF!