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

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.

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!