MotherDuck Fivetran Destination connector

This is a MotherDuck implementation of Fivetran connector SDK

This connector requires two user-configurable properties:

• Authentication Token Users can retrieve the token from app.motherduck.com (documentation).
• Database The MotherDuck database to load the data into. If the database does not exist, it will be created at the first Fivetran request mentioning it.

Local build

To install dependencies:

make build_dependencies

To build the destination server:

make build_connector
OR 
make build_connector_debug

To run the destination server:

./build/Release/motherduck_destination [--port CUSTOM_PORT]
OR
./build/Debug/motherduck_destination [--port CUSTOM_PORT]

By default, the server runs on 0.0.0.0:50052.

Local testing

One-time setup:

make build_test_dependencies

To run integration tests (which will create a database named fivetran_test in your production MotherDuck account):

make build_connector_debug
./build/Debug/integration_tests

Upgrading DuckDB

This connector uses DuckDB's amalgamation sources. To upgrade, change DUCKDB_VERSION in Makefile and re-run make get_duckdb.

TODO

• support GZIP compression