MotherDuck

Prerequisites
Connection Setup
1. Database Name
2. Authentication Token
Write Modes
Append
Replace
Upsert

MotherDuck is the cloud-hosted version of DuckDB. MantrixFlow connects using the database name and a MotherDuck authentication token.

Prerequisites

You need a MotherDuck account. Create a database and obtain an authentication token from the MotherDuck web interface.

Connection Setup

1. Database Name

Enter the name of the MotherDuck database you want to write to.

2. Authentication Token

Obtain a token from the MotherDuck web interface (Account → Access Tokens). Paste the token into the credentials field.

Write Modes

Append

Appends rows to the existing table. The table is created if it does not exist.

Replace

Drops and recreates the table on every sync.

Upsert

Uses the specified field as the document identifier for update operations. Specify the upsert key column.

DuckDB

MySQL (Destination)

Introduction

Getting started

Connections

Pipelines

Sync reference

Transformations

Platform

Prerequisites

Connection Setup

1. Database Name

2. Authentication Token

Write Modes

Append

Replace

Upsert

Introduction

Getting started

Connections

Pipelines

Sync reference

Transformations

Platform

​Prerequisites

​Connection Setup

​1. Database Name

​2. Authentication Token

​Write Modes

​Append

​Replace

​Upsert

Prerequisites

Connection Setup

1. Database Name

2. Authentication Token

Write Modes

Append

Replace

Upsert