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 scaling token for the Omni connection. This is the recommended default for querying and dashboards.
  • A Read/Write token only if you plan to use Omni's table uploads.

Setup​

  1. In MotherDuck, create a read scaling token for Omni and copy it before closing the dialog. Omni's own setup documentation suggests a Read/Write token; that only applies if you need table uploads.
  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.
note

A read scaling token is the recommended default. Only use a Read/Write token if you need Omni's optional table uploads.

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​