MotherDuck

Learn the required and optional properties of creating a MotherDuck Connection, Credential, and Write Connector.

motherduck logo

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.

FieldRequiredDescription
Connection NameRequiredInput your desired Connection name.
Connection TypeRequiredThe Connection Type automatically defaults to MotherDuck
Access typeRequiredWrite-Only. MotherDuck is a Write-Only Connection.
DatabaseRequiredThe database name you are writing data to. See MotherDuck documentation for database operations and to find your database name(s).
Requires CredentialsOptionalEnable "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.

FieldRequiredDescription
Credential NameRequiredThe name to identify this credential with. This credential will be available as a selection for future use.
Credential TypeRequiredThis field will automatically populate with MotherDuck.
Service TokenRequiredYour 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.

FieldRequiredDescription
NameRequiredProvide a name for your Write Connector. We recommend using lowercase with underscores in place of spaces.
DescriptionOptionalDescribes the connector. We recommend providing a description if you are ingesting information from the same source multiple times for different reasons.
DatabaseOptionalThe name of the database to write the table in if different from the database within the MotherDuck Connection.
table NameRequiredName of the table to create when writing data.

💡

The Description field for Connection and Connectors supports markdown formatting.