Skip to main content

MotherDuck

Connect to MotherDuck.

Note: Omni supports MotherDuck Version 10.2+

Creating the connection in Omni​

  1. Login to your MotherDuck account.
  1. Copy the name of the database that you want to connect to in Omni. a. Navigate to the vertical three-dot menu, next to the database’s name and select Copy name
  1. In Omni, navigate to the Admin tab (top-right as an Admin user) > Connections (lower-left in left menu) > Add Connection (top-right) > Select MotherDuck.

Use this image to follow along with the next steps:​

  • 3.1. Display Name is a required field. This name will appear will appear in the Omni Connections list.

  • 3.2 Database is a required field. This should reference the default database (catalog) in MotherDuck that Omni will connect to. Paste the database name value copied from step 2.

  • 3.3. Include Other Catalogs is an optional field. If you want to include multiple catalogs though, simply copy those catalogs’s names into a comma-separated list in this field.

  • 3.4. Include Schemas is an optional field that allows you to limit which schemas to allow Omni to access.

    • 3.4.1. List the schemas you want included

    • 3.4.2. If none are listed, Omni will be able to access all schemas within the listed database(s).

    • 3.4.3. If you included a secondary catalog in step 3.3, be sure to reference the secondary catalog and the schema separated by a period, e.g. other_catalog.schema.

  • 3.5 Token is a required field.

    • 3.5.1. Navigate back to your MotherDuck settings.

    • 3.5.2. Select the Copy Token button.

    • 3.5.3. Navigate back to the database connection page in Omni.

    • 3.5.4. Paste the token you just copied.

  1. Select “Create Connection” and voila! You can see your new connection in action by heading over to the “Make a workbook” or “Browse Model” options in the “Woo hoo!” success modal in the top right.

What's next?​

Now that Motherduck is set up, you can: