See Stacksync in action with a solution architect. Book a demo ↗
StacksyncDocs
StacksyncCommunityBook a demoContact Support
HomeTwo-way syncAgentic WorkflowsGeniesEnterprise OSMCPEDIConnectorsSecurity and Other ResourcesChangelogDevelopers
Page cover

MotherDuck

Two-way sync between MotherDuck and your other systems.

Introduction

MotherDuck is a cloud analytics platform built on top of DuckDB, designed to deliver fast and efficient data analysis in the cloud. By combining the simplicity of DuckDB with the scalability of cloud infrastructure, MotherDuck allows teams to run complex queries on larger datasets without needing extensive infrastructure. It integrates seamlessly with popular data tools, offering a user-friendly experience for data engineers, analysts, and developers who seek powerful, scalable analytics in a lightweight platform.

Authorize MotherDuck

  1. In MotherDuck, navigate to Settings > General and select Create Token.
MotherDuck Settings General page with Access tokens section and the "Create token" button highlighted.
  1. Enter a name for your token, then click Create.
MotherDuck "Create token" dialog with the name "stacksync" entered and the "Create token" button highlighted.
  1. Copy the generated access token.
MotherDuck "Created stacksync" dialog showing the generated access token to copy before closing.
  1. Log in to Stacksync and click on Connections > Create new connection.
  2. Search for MotherDuck and select it.
Stacksync "Create a Connection" Select App step with the MotherDuck tile highlighted.
  1. Paste the access token here. If you're using a database name or schema other than the default, update those settings accordingly.
Stacksync Motherduck dialog with the "Motherduck Access Token" field, database "my_db", schema "main" and "Authorize App" highlighted.

You can now use your MotherDuck connection in a sync!

Sensitive fields

HubSpot requires additional authorization before sensitive fields can be synced. This page explains how to enable access to sensitive fields on our platform.

Snowflake

Two-way sync between Snowflake and your other systems.

On this page

Authorize MotherDuck