💡 Feature Idea for DuckDB Destination: Add support for MotherDuck

[aaronsteers]

What

This feature would allow the DuckDB destination to connect to MotherDuck.

Why

MotherDuck users would be able to load data using Airbyte OSS and Airbyte Cloud.

This also enabled DuckDB destination for use in Airbyte Cloud. It otherwise cannot be used in Cloud due to only being able to write out to local files.

[aaronsteers]

Some technical details:

Authentication via a MotherDuck Service Token

https://motherduck.com/docs/authenticating-to-motherduck#authentication-using-a-service-token

Databases can be attached using the share URL

ATTACH 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6';
USE sample_data;

Ref: https://motherduck.com/docs/key-tasks/querying-a-shared-motherduck-database