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

Skip to main content

Omni

Modern business intelligence platform for creating interactive dashboards and data visualizations. It integrates with MotherDuck for dashboards, semantic models, and embedded analytics workflows.

How it works with MotherDuck​

Omni connects to MotherDuck as a database connection for modeling, dashboards, AI-assisted exploration, and embedded analytics.

Prerequisites​

  • Organization Admin permissions in Omni.
  • A MotherDuck database available on MotherDuck v0.10.2 or later.
  • A MotherDuck Read/Write token for the Omni connection.

Setup​

  1. In MotherDuck, create a Read/Write token for Omni and copy it before closing the dialog.
  2. Optional: create a dedicated schema for Omni table uploads if users need to upload CSVs and join them to modeled data.
  3. In Omni, open Settings > Connections.
  4. Select MotherDuck.
  5. Paste the MotherDuck token and complete the connection form.
  6. Create the connection.

Authentication and configuration​

  • Use a dedicated token for the Omni connection.
  • Configure schema filters to limit what Omni imports into its model.
  • Use a separate upload schema if Omni users will upload files. Do not reuse that schema for modeled tables.
  • Review timezone settings during setup so dashboard results match your reporting conventions.

Important notes​

  • Omni recommends a Read/Write token because Omni may need to support table uploads and modeling workflows.
  • Table uploads are optional. If you do not use them, you can keep the connection focused on querying existing MotherDuck tables.

Use cases​

  • Generate an Omni model from MotherDuck schemas.
  • Build BI dashboards and topics on top of MotherDuck.
  • Combine user-uploaded files with governed MotherDuck data in Omni.

Related content​