Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

Artie

Artie is a fully managed CDC streaming platform that allows you to replicate data from your source database to your destination in real-time. It integrates with MotherDuck for loading data from operational systems, APIs, files, or event streams.

How it works with MotherDuck​

Artie can write CDC and streaming pipeline output into MotherDuck.

Prerequisites​

  • An Artie pipeline.
  • A MotherDuck Read/Write token.
  • A target MotherDuck database name.
  • Optional: a dedicated MotherDuck service account for pipeline writes.

Setup​

  1. Create a Read/Write token in MotherDuck. You can create it from a regular user account or from a service account.
  2. In Artie, configure MotherDuck as the destination.
  3. Enter the MotherDuck token and database name.
  4. Start the pipeline and verify that the database appears in MotherDuck.
  5. If you used a service account, impersonate that service account to inspect objects it created.

Authentication and configuration​

  • Artie requires a Read/Write token because the pipeline writes data.
  • A dedicated service account is recommended for production pipeline writes.
  • If team members need access to tables written by the service account, create an organization share from the service account-owned database.

Important notes​

  • Data written through a service account is visible to that service account by default. Share it explicitly with the organization if analysts need access.
  • Copy MotherDuck tokens when they are created because they are only shown once.

Use cases​

  • Replicate CDC streams into MotherDuck.
  • Keep operational sources synchronized with MotherDuck analytics tables.
  • Use Artie pipelines to land data into a database owned by a dedicated service account.

Related content​