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

Skip to main content

Explo

Explo is a platform for embedded analytics, AI analytics, and data sharing in customer-facing products. It integrates with MotherDuck as a data source.

How it works with MotherDuck​

Explo connects to MotherDuck as a data source for embedded analytics and customer-facing dashboards.

Prerequisites​

  • A MotherDuck database for Explo to query.
  • A MotherDuck access token provisioned for the Explo workspace.
  • The database name and any schema names you plan to expose in Explo.

Setup​

  1. In MotherDuck, create an access token for Explo.
  2. In Explo, create a new data source and select MotherDuck.
  3. Enter the MotherDuck database name.
  4. Choose the authentication option that uses an access token.
  5. Paste the token and save the data source.

Authentication and configuration​

  • Use a dedicated token for each Explo environment or workspace.
  • Prefer read-only access for embedded analytics workloads.
  • Configure schema access in Explo so customer-facing dashboards only expose the intended data model.

Important notes​

  • Explo's MotherDuck documentation lists the required credentials but does not require a platform-specific environment variable list.
  • Keep the token in Explo's credential store and rotate it like any other production credential.

Use cases​

  • Power embedded dashboards from MotherDuck tables.
  • Build customer-facing analytics over per-customer or shared schemas.
  • Let Explo query curated datasets without moving data into another warehouse.

Related content​