We are beyond excited to announce that Paradime is partnering up with the brilliant team at MotherDuck to help analytics engineers adopt DuckDB with ease. 

It feels extra good to be able to say that we are the only Code IDE on the market that supports MotherDuck and DuckDB toolchain 'out-of-the-box'. With this integration, analytics engineers can now develop dbt™ models in the Paradime Code IDE on top of MotherDuck and DuckDB seamlessly in a managed dbt™ native workspace.

Through this integration we are unlocking a few new use-cases in the cloud:

• Single-file OLAP databases available in a cloud environment (or cloud VM)
• First time ever analytics teams can cut out cloud warehouse compute costs during development within a cloud environment
• Terminal UIs in the cloud - (if you are reading this post and you have a cool terminal UI idea or project, hit us up - let's work together)
• Toolchain for teams on Postgres without a cloud data warehouse to perform analytics
• Toolchain to perform analytics on data stored in JSON, Parquet, Iceberg and other formats in S3 or other Lake type storage

What's shipping: 

1. MotherDuck integration - power collaborative and serverless analytics

Paradime now has native support for MotherDuck. MotherDuck users will now be able to setup their DuckDB in Paradime, do all their dbt™ development on top of local DuckDB, and push their local DuckDB to MotherDuck.

2. dbt-duckdb - build and run dbt™ models

The dbt-duckdb adapter gives analytics engineers superpowers to build and run dbt™ models against their local DuckDB and push new datasets to MotherDuck. If you are on Postgres and don't want to invest in a cloud data warehouse just yet, this is the solution for you. If you have most of your data in S3 buckets, and not ingested in your warehouse, you can use Paradime, MotherDuck and dbt-duckdb to build out your analytics stack on local compute.

3. DuckDB CLI

The DuckDB CLI is included in the terminal environment. Users can perform analytics queries on CSV, Iceberg, Parquet, JSON and other formats from the terminal. By using any of the supported DuckDB extensions, users can create local DuckDBs and write SQL queries on them.

4. Harlequin IDE - a fully functional query IDE in the Paradime terminal

To facilitate SQL querying, the powerful Harlequin SQL IDE is also included. Now, you can open any local DuckDB file in Harlequin inside a Paradime terminal and get the full power of terminal UI on the cloud. Using terminal UIs in the cloud makes the terminal's user experience 100x better (if we might say so ourselves) and accessible for anyone to get started.

5. DuckDB extensions - use any supported DuckDB extension

Every supported DuckDB extension is available to use. You see, here at Paradime, we are not big fans of constrains and limitations - and neither are our users.

Conclusion

By adding support for MotherDuck, we are taking another step forward in our mission to support analytics teams and make sure our users stay ahead of the innovation curve in the ever-evolving data & analytics landscape. Our goal with Paradime is to build the most user-centric, feature-complete analytics development experience on the market - and that also means partnering up with the best of the best and those willing to push the boundaries of what is possible to build bleeding edge tooling.
‍
Are you keen to hear about how the Paradime team is building the most user-centric, feature-complete analytics development experience on the market? Or maybe you want to partner up with us? Either way, don't forget to get in-touch!

‍

Let’s go 🤘