Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

Paradime

Modern data transformation platform for building and managing data pipelines. It integrates with MotherDuck for running data transformation projects against MotherDuck.

How it works with MotherDuck​

Paradime connects dbt development environments to MotherDuck so dbt models can run against a MotherDuck database.

Prerequisites​

  • A Paradime workspace and dbt project.
  • A MotherDuck service token.
  • The MotherDuck database path and default schema for dbt models.

Setup​

  1. In Paradime, open Settings > Connections.
  2. Select Add New under the Code IDE connection section.
  3. Choose MotherDuck.
  4. Enter the dbt profile name and target.
  5. Configure the profile with the MotherDuck database path, for example md:jaffle_shop_dev.
  6. Paste the MotherDuck service token.
  7. Enter the default schema and thread count.
  8. Save the connection and validate it from the Paradime terminal or by running a small dbt model.

Paradime MotherDuck connection form

Authentication and configuration​

  • Paradime stores the MotherDuck token as a user-level environment variable named motherduck_token.
  • If your Paradime environment uses IP restrictions, allow traffic from the Paradime IP range for your selected data location.
  • Configure extensions and DuckDB settings only when your dbt project needs them, such as reading or writing external files.

Important notes​

  • The Paradime docs include an example with S3 and Parquet settings. Those are optional project settings, not required for a basic MotherDuck connection.
  • Keep the MotherDuck token at user level so different developers can use their own credentials when needed.

Use cases​

  • Develop dbt models in Paradime against MotherDuck.
  • Run validation queries from the Paradime terminal.
  • Schedule dbt transformations that target MotherDuck.

Related content​