Skip to main content

Upgrading to DuckDB 0.10.2

DuckDB 0.10.2​

Starting May 15, 2024, MotherDuck supports DuckDB version 0.10.2. You are encouraged to upgrade:

  • All new accounts created after May 15, 2024 are defaulted to 0.10.2 or later and cannot use earlier versions of DuckDB with MotherDuck.
  • If you are on DuckDB version 0.9.2, you can now permanently migrate your MotherDuck account to DuckDB version 0.10.2 or later.
  • If you are on DuckDB version 0.9.2, you may also preview DuckDB version 0.10.2 and go back to version 0.9.2 for the time being.

Starting with DuckDB version 0.10.2, we've relaxed the restriction of having to use a single version of DuckDB with MotherDuck. You can now use MotherDuck with a variety of versions of DuckDB.

Permanently Migrate to DuckDB Version 0.10.2 in MotherDuck​

You are encouraged to permanently migrate to DuckDB version 0.10.2 or later. This is a fast operation that cannot be reversed. This choice is made per-user, not per-organization. All your databases and shares will be migrated to be compatible with 0.10.2+ and will no longer be usable from DuckDB version 0.9.2 or earlier.

If you migrate to DuckDB version 0.10.2, only clients running DuckDB version 0.10.2 or later will be able to connect to MotherDuck. This includes the DuckDB CLI, Python, and any 3rd party software you may use in concert with MotherDuck, such as BI or ETL tools.

To permanently migrate your MotherDuck account to version 0.10.2 or later:

  • Open the MotherDuck Web UI and navigate to Settings.
  • Under “General” find section titled “DuckDB Compatibility Mode”
  • Press “Permanently migrate to 0.10.2+”
note

If you're already in 0.10.2+ Preview Mode, please revert back to 0.9.2 in the MotherDuck UI first before permanently migrating to 0.10.2

Migrate to 0.10.2

  • All clients (e.g. Python, CLI, etc) you use to connect to MotherDuck must be on 0.10.2.

Previewing DuckDB Version 0.10.2 in MotherDuck​

Today you can choose to preview DuckDB version 0.10.2 in MotherDuck. This is a reversible decision, as you can go back to DuckDB 0.9.2 at any time. This choice is made per-user, not per-organization. We recommend you leverage a non-production account for this purpose.

To preview version 0.10.2 in MotherDuck:

  • Open the MotherDuck Web UI and navigate to Settings.
  • Under “General” find section titled “DuckDB Compatibility Mode”
  • Press “Try the 0.10.2+ preview” Preview 0.10.2
  • All clients (e.g. Python, CLI, etc) you use to connect to MotherDuck must be on 0.10.2.

When in 0.10.2+ preview mode, you are subject to the following limitations:

  • Existing databases (databases created in 0.9.2) will only be available in read-only mode.
  • New writeable databases can be created in the 0.10.2+ preview. If you go back to 0.9.2, these databases will be visible, but they won’t be accessible in 0.9.2 mode.
  • The MotherDuck Wasm client cannot yet be used with 0.10.2.

Partner Connections​

Accessing MotherDuck via a partner, such as Omni, Dbt, Preset, or Hex, 0.10.2 will not work until they complete the upgrade to 0.10.2. If you are using 3rd party tools with MotherDuck, please confirm with either MotherDuck or the 3rd party vendor that they are on DuckDB version 0.10.2 before migrating your MotherDuck account to version 0.10.2.

Version Independence​

Starting with DuckDB Version 0.10.2, MotherDuck supports using multiple versions of DuckDB at a time. For example, you could use DuckDB 0.10.3 in the CLI and DuckDB 1.0 in Python.

The minimum version supported for Version Independence is 0.10.2, so you’ll need to upgrade your clients to at least this version one last time.