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

Skip to main content

Fivetran Activations (formerly Census)

Fivetran Activations, formerly Census, syncs modeled data from a warehouse or database into operational and customer engagement tools. MotherDuck is available as a source in Fivetran Activations, which means Activations can read from MotherDuck and sync selected data to supported activation destinations.

This is different from the Fivetran MotherDuck destination, which loads data from other sources into MotherDuck.

How it works with MotherDuck​

Fivetran Activations can use MotherDuck as a source for reverse ETL syncs into operational tools.

Prerequisites​

  • A Fivetran Activations workspace or trial.
  • A MotherDuck service token.
  • Modeled tables or views in MotherDuck that contain the records you want to activate.

Setup​

  1. In MotherDuck, create or copy a service token.
  2. In Fivetran Activations, open Sources.
  3. Select New Source and choose MotherDuck.
  4. Enter the MotherDuck service token and connect the source.
  5. Open Syncs and create a sync from the MotherDuck source to your target destination.

Authentication and configuration​

  • Use a dedicated service token for Activations.
  • Expose stable tables or views for activation syncs so field mappings remain consistent.
  • Start with a limited audience or test destination object before enabling production syncs.

Important notes​

  • Fivetran Activations uses MotherDuck as a source, not as a destination.
  • Fivetran's docs note MotherDuck support through the Basic Sync Engine. Check the linked docs for current engine support before designing large activation workflows.

Use cases​

  • Sync product-qualified leads or account scores from MotherDuck to CRM tools.
  • Push modeled user segments from MotherDuck to marketing platforms.
  • Activate customer event or enrichment data produced in MotherDuck.

Related content​