DQC Logo
|

Connection to MotherDuck

To connect a MotherDuck database to the DQC Platform, you need a MotherDuck access token plus the name of the database you want to query. MotherDuck is a managed cloud version of DuckDB — once connected, every table in the selected database becomes available for data quality checks.


Add a MotherDuck connector

To begin:

  1. Go to the Connectors > Data sources screen

  2. Click the MotherDuck tile

  3. Enter the connection parameters described below


undefined Required connection information

Field

Example

Description

Name

Marketing MotherDuck

A custom name to identify this connector inside DQC

MotherDuck Token

eyJhbGciOiJIUzI1NiIsInR5...

Your MotherDuck access token. Generate one in the MotherDuck UI under Settings → Tokens.

Database

my_db

Name of the database to connect to. Bound to the connector and cannot be changed after creation.

DB Schema

main

Schema inside the database. Defaults to main if left empty. Bound to the connector and cannot be changed after creation.


undefined Generate a MotherDuck token

  1. Sign in to the MotherDuck UI

  2. Open Settings > Tokens and create a new read-only token (recommended)

  3. Copy the token immediately — MotherDuck will not show it again

  4. Paste it into the MotherDuck Token field in DQC

Tokens are stored encrypted; only the first and last few characters are displayed in the UI after saving.


undefined What gets imported

  • All tables in the selected database and schema become available as DQC tables

  • Views are included if visible to the token's user

  • Schema and database are fixed per connector — to switch databases, create a new connector


undefined Connect and assign permissions

After saving, DQC validates the token, lists the available tables and lets you pick which ones to expose. To control who can use the connector inside DQC, see Data source access permissions.