MotherDuck

About

Polytomic can run ETL and sync workloads with MotherDuck in both directions. The following workloads are supported:

• ELT (loading data from external sources into MotherDuck)
• ETL (transforming data with SQL queries before loading it into MotherDuck
• CDC streaming from databases like PostgreSQL, MySQL, DynamoDB, and others.
• Reverse ETL (syncing from MotherDuck to SaaS applications like Salesforce, Zendesk, and others).

Connecting Polytomic to MotherDuck

Polytomic connects to MotherDuck using a MotherDuck Access Token:

1. Generate a MotherDuck Access Token by following MotherDuck's instructions .

2. In Polytomic, go to Connections → Add Connection → MotherDuck.

3. Optional: if you will be writing to MotherDuck, set up an S3 bucket with an Access Key ID and Secret Key.

4. Paste your MotherDuck Access Token in your Polytomic connection. Also include your S3 credentials if you will be writing to MotherDuck:

5. Click Save.

Syncing to MotherDuck

Use Bulk Syncs to sync to MotherDuck from your databases and SaaS applications.

Use Model Syncs to sync to MotherDuck from custom SQL queries (e.g. from a custom SQL query on PostgreSQL).

Syncing from MotherDuck

Use Model Syncs to sync from MotherDuck to SaaS applications like Salesforce, spreadsheets like Google Sheets and Airtable, and webhooks.