MotherDuck
Learn the required and optional properties of creating a MotherDuck Connection, Credential, and Write Connector.
Prerequisites
- MotherDuck service token
- A MotherDuck database
Connection Properties
The following table describes the fields available when creating a new MotherDuck Connection. Create a connection using the information below and these step-by-step instructions.
Field | Required | Description |
---|---|---|
Connection Name | Required | Input your desired Connection name. |
Connection Type | Required | The Connection Type automatically defaults to MotherDuck |
Access type | Required | Write-Only . MotherDuck is a Write-Only Connection. |
Database | Required | The database name you are writing data to. See MotherDuck documentation for database operations and to find your database name(s). |
Requires Credentials | Optional | Enable "Requires Credentials" if this connection is to a private location that requires credentials to be passed through as part of authentication. |
Credential Properties
The following table describes the fields available when creating a new MotherDuck credential.
Field | Required | Description |
---|---|---|
Credential Name | Required | The name to identify this credential with. This credential will be available as a selection for future use. |
Credential Type | Required | This field will automatically populate with MotherDuck . |
Service Token | Required | Your MotherDuck service token. See MotherDuck documentation to locate the token. |
Write Connector Properties
The following table describes the fields available when creating a new MotherDuck Write Connector. Create a new Write Connector using the information below and these step-by-step instructions.
Field | Required | Description |
---|---|---|
Name | Required | Provide a name for your Write Connector. We recommend using lowercase with underscores in place of spaces. |
Description | Optional | Describes the connector. We recommend providing a description if you are ingesting information from the same source multiple times for different reasons. |
Database | Optional | The name of the database to write the table in if different from the database within the MotherDuck Connection. |
table Name | Required | Name of the table to create when writing data. |
The Description field for Connection and Connectors supports markdown formatting.
Updated 9 months ago