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

Skip to main content

Gooddata

Enterprise analytics platform for building data products and embedded analytics. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows.

How it works with MotherDuck​

GoodData Cloud connects to MotherDuck as a data source for semantic models, dashboards, and embedded analytics.

Prerequisites​

  • A GoodData Cloud workspace with permission to create data sources.
  • A MotherDuck service token.
  • The MotherDuck database name and schema GoodData should use.

Setup​

  1. In GoodData Cloud, open Data sources and select Connect data.
  2. Select MotherDuck.
  3. Enter a data source display name.
  4. Paste the MotherDuck service token.
  5. Enter the database name and schema.
  6. Select Connect.

GoodData MotherDuck data source form with service token, database, and schema fields

GoodData also supports creating the data source through its API. When using the API, encode the MotherDuck service token as required by the GoodData request body and use a JDBC URL such as jdbc:duckdb:md:<database_name>.

Authentication and configuration​

  • Use a MotherDuck service token dedicated to the GoodData data source.
  • Enter a schema so GoodData can build its logical data model from the intended tables.
  • Keep the service token in GoodData's credential handling or your deployment secret store if you create the data source through the API.

Important notes​

  • GoodData's guide includes both UI and API setup. Start with the UI unless you need repeatable provisioning.
  • GoodData's API examples include GoodData API authentication details; those are separate from the MotherDuck service token.

Use cases​

  • Build governed BI workspaces on top of MotherDuck.
  • Create embedded analytics backed by MotherDuck tables.
  • Provision MotherDuck data sources with GoodData's API for repeatable environments.

Related content​