Data and AI releases

548 this month · 176 companies

- Duplicate MotherDuck notebook cells: Duplicate cells in MotherDuck UI notebooks using the cell options menu...

UpdateNot yet verified

- Duplicate MotherDuck notebook cells: Duplicate cells in MotherDuck UI notebooks using the cell options menu or command menu. Access the duplicate option from the three-dot options menu on any cell, or use Cmd/Ctrl + Shift + P to open the command menu and search for "duplicate."

Notebooks

Read on motherduck.com

Also shipped Oct 24, 2025MotherDuck in October 2025 →

What's new in Sigma

API Impersonate a user in API calls (Beta) A user assigned the Admin account type can impersonate other users in API calls, for example to retrieve and display the contents of their My Documents folder in embedded content. For more details and an example test Python script, see Impersonate users .

Beta
Source ↗

Magic Config, HTTP Metrics, Secure DB queries

Last week, one of our newest additions was repo-aware settings, giving you autocomplete for your Railway config paths. This week? We're doubling down on the zero-config magic. Railway now automatically detects the environment variables your code needs and surfaces them right when you're configuring your service.

GA
Source ↗

More from MotherDuckEvery MotherDuck release →

Performance improvements

- Sorting is 2x+ faster: Complete rewrite of sorting uses less memory and scales better across threads for ORDER BY, window functions, and list sorting More efficient small writes: Appending small numbers of rows now writes far fewer bytes 5x faster checkpointing: Reuses table metadata when tables aren't altered during checkpoint Parallel connection...

Update
Source ↗

SQL syntax updates

- MERGE INTO statement: Standard SQL upserts without requiring primary keys or indexes FILL() window function: Interpolate missing values in ordered data Python-style macro arguments: Macros accept positional or named arguments for any parameter STRUCT to MAP cast: Direct casting between struct and map types

Update
Source ↗

Parquet improvements

- VARIANT type reading: Read Parquet VARIANT types for faster semi-structured data processing Native geometry type writes: Write native Parquet geometry types Auto-globbing for directories: Automatically treats paths as directories and retries with glob patterns when no file is found Learn more in the official DuckDB Labs announcements for 1.4.0 and 1.4.1 .

Update
Source ↗

[Preview] DuckLake 0.3

As we announced earlier this year, MotherDuck now supports DuckLake , an integrated data lake and catalog format. DuckLake 0.3 makes working with DuckLake more robust, including CHECKPOINT for easy maintenance , new paths for Iceberg interoperability, spatial geometry types , and MERGE INTO support .

Preview
Source ↗

- DuckDB 1.4.2: MotherDuck supports DuckDB 1.4.2, a bugfix release

- DuckDB 1.4.2: MotherDuck supports DuckDB 1.4.2, a bugfix release. Learn more in the official DuckDB Labs 1.4.2 announcement and changelog . Full command menu now at Cmd/Ctrl+K : Access common MotherDuck UI actions from your keyboard, including generating query edits, adding notebook cells, creating notebooks, and navigating between pages.

Update
Source ↗