MotherDuck
Ingest data from a MotherDuck database with a SQL query.
The MotherDuck connector ingests data from a MotherDuck database. You give it a query, and the rows it returns become a table in Gaur.
Create a secret
The MotherDuck connector needs a MotherDuck secret. Create one with connector type MotherDuck and these fields:
| Field | Required | Description |
|---|---|---|
token | Yes | Your MotherDuck access token. |
database | No | The MotherDuck database to read from. |
Generate the token from your MotherDuck account. The token is encrypted and reused for every ingestion and refresh from this database.
Ingest a table
Choose the MotherDuck connector
In the Ingestion area, pick MotherDuck and select the MotherDuck secret you created.
Write the query
Provide a SELECT query for the data you want. Its result set becomes the
table.
Name the table and ingest
Name the resulting table. Gaur runs the ingestion as a background job, infers the schema, and creates the table.
Refreshing
Keep MotherDuck tables current with refreshes, on demand or on a schedule.