Skip to main content

MotherDuck Adaptor

About MotherDuck​

MotherDuck is a serverless cloud data warehouse built on DuckDB that makes big data feel small. It combines the power of DuckDB's analytical engine with cloud scalability, offering ultra-fast analytics without the operational complexity of traditional data warehouses.

Integration Options​

MotherDuck supports REST API integration with OpenFn:

REST API: MotherDuck provides API access that enables external services like OpenFn to interact with cloud databases, execute SQL queries, and manage data warehousing operations. See functions for more on how to use this adaptor to work with the MotherDuck API.

Authentication​

  1. See MotherDuck docs for the latest on supported authentication methods.
  2. When integrating with MotherDuck via OpenFn, the primary authentication method is Token. You can generate a token from your MotherDuck account settings.
  3. See this adaptor's Configuration docs for more on the required authentication parameters.

See platform docs on managing credentials for how to configure a credential in OpenFn. If working locally or if using a Raw JSON credential type, then your configuration will look something like this:

{
  "token": "token_abc123...",
  "database": "my_database",
  "sessionHint": "primary"
}
  1. MotherDuck Documentation
  2. MotherDuck Official Website

Implementation Examples​

Coming soon!

I've noticed a problem with this Adaptor, or something is out of date, what can I do?​

Thanks for asking! We are a fully Open Source Digital Public Good, and we welcome contributions from our community. Check out our Adaptors Wiki for more information on how you can update Adaptors!

Or, you can always reach out to the Community through our Community Forum here.