What's Changed

🎉 Exciting New Features

🦆 MotherDuck Support

This one's for all the ducklings out there! In addition to supporting DuckDB, Mage now supports MotherDuck destinations!

By specifying a MOTHERDUCK_TOKEN and adding a md: prefix to your DuckDB database, you can read/write from/to MotherDuck locations! Check it out and get started here.

by @wangxiaoyou1993 in https://github.com/mage-ai/mage-ai/pull/4533

🤖 Support Thick mode in OracleDB

We like our OracleDB connections like we like our pancakes, THICK 🥞. By default, Mage's Oracle client runs in a "Thin" mode which connects directly to Oracle Database— this mode does not need Oracle Client libraries. However, some additional functionality is available when they're used.

Now, you can use the "Thick" mode in Mage to connect to OracleDB using the Oracle Client libraries!

Check out our docs to get started or read more about the differences between "Thin" and "Thick" modes here.

by @matrixstone in https://github.com/mage-ai/mage-ai/pull/4421

🗄️ Show unused block files in file browser

This is one of our most requested features and we're excited to announce that it's finally here! 🎉

You can now see which files are not being used in your pipeline! This is a great way to clean up your projects and remove any unnecessary files. Check out the gif below to see it in action!

Head over to our docs to learn more!

by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4449

🤐 Import functionality for pipeline zips

Like to share? So do we! You can now import pipelines (via .zip files) in your Mage projects! We're optimistic that this simple improvement will make it easier to share your pipelines or even borrow pipelines from your friends!

by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4453

🐛 Bug Fixes

• Prevent add block menu from disappearing by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4502
• Fix some minor bugs by @tommydangerous in https://github.com/mage-ai/mage-ai/pull/4505
• Remove table name helper by @tommydangerous in https://github.com/mage-ai/mage-ai/pull/4506
• Fix alter table column names cleaning (Postgresql integration exporter) by @arnetkachev in https://github.com/mage-ai/mage-ai/pull/4493
• Fixed Oauth connection on Salesforce Source by @Luishfs in https://github.com/mage-ai/mage-ai/pull/4402
• Fix unclickable vertical scrollbar and jumping before panel by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4512
• Catch unknown host error by @wangxiaoyou1993 in https://github.com/mage-ai/mage-ai/pull/4518
• Upgrade snowflake library version and fix datetime column type by @wangxiaoyou1993 in https://github.com/mage-ai/mage-ai/pull/4524
• Only show files with correct prefix by @dy46 in https://github.com/mage-ai/mage-ai/pull/4509
• Update submodule sync for ssh auth by @dy46 in https://github.com/mage-ai/mage-ai/pull/4522
• Update connection url by @dy46 in https://github.com/mage-ai/mage-ai/pull/4523
• Update how the stale pipeline message modal is displayed by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4536
• Fix running dynamic blocks with k8s executor by @wangxiaoyou1993 in https://github.com/mage-ai/mage-ai/pull/4543
• Widget policy update by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4545
• Catch exception of building cache key for block cache by @wangxiaoyou1993 in https://github.com/mage-ai/mage-ai/pull/4548
• Disable stale pipeline modal by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4525

💅 Enhancements & Polish

• MSSQL data integration source - add support for DATETIMEOFFSET type by @hugabora in https://github.com/mage-ai/mage-ai/pull/4499
• Fix: handle unprivileged user for postgres by @jdbranham in https://github.com/mage-ai/mage-ai/pull/4357
• Optimize pipeline schedule queries by @dy46 in https://github.com/mage-ai/mage-ai/pull/4188
• Remove pipeline's updated_at attribute by @johnson-mage in https://github.com/mage-ai/mage-ai/pull/4521
• Create and view workspaces in different namespaces by @dy46 in https://github.com/mage-ai/mage-ai/pull/4513
• Select status for pipeline runs that time out by @dy46 in https://github.com/mage-ai/mage-ai/pull/4519

New Contributors

• @arnetkachev made their first contribution in https://github.com/mage-ai/mage-ai/pull/4493
• @jdbranham made their first contribution in https://github.com/mage-ai/mage-ai/pull/4357
• @tanjibpa made their first contribution in https://github.com/mage-ai/mage-ai/pull/4528

Full Changelog: https://github.com/mage-ai/mage-ai/compare/0.9.62...0.9.63