Skip to main content

Orchestra

Orchestra is a platform for building and managing data pipelines. It integrates with MotherDuck for scheduling DuckDB and MotherDuck tasks in repeatable data workflows.

How it works with MotherDuck​

Orchestra connects to MotherDuck with the DuckDB Python client and can run scheduled SQL tasks against a configured MotherDuck database.

Prerequisites​

  • Access to the Orchestra MotherDuck integration. Orchestra marks the integration as beta in its docs.
  • A MotherDuck database.
  • A MotherDuck access token with the permissions required for the SQL Orchestra will run.

Setup​

  1. In MotherDuck, create an access token.
  2. In Orchestra, create a MotherDuck integration connection.
  3. Enter the MotherDuck database name.
  4. Paste the access token.
  5. Use the MotherDuck Run SQL action in a pipeline.

Orchestra MotherDuck access token instructions

Authentication and configuration​

  • The required authentication parameters are the database name and access token.
  • Use a dedicated token for Orchestra pipelines.
  • Choose token permissions based on whether the SQL task reads only or writes data.

Important notes​

  • The Orchestra MotherDuck integration is documented as beta, so availability may vary by account.
  • Store the token in Orchestra's connection configuration rather than embedding it in SQL tasks.

Use cases​

  • Schedule SQL transformations in MotherDuck.
  • Add MotherDuck query tasks to larger Orchestra data pipelines.
  • Run operational checks or data maintenance SQL on a schedule.

Related content​