Trigger Census Syncs

Learn how to automatically trigger Census syncs when your dbt™ runs complete successfully in Bolt. This integration helps data teams maintain synchronized data by sending fresh data to operational tools immediately after successful pipeline runs.

What You'll Get

When a run succeeds, Bolt automatically triggers your Census sync:

  • Census receives the webhook

  • Sync process begins immediately

  • Fresh data flows to your operational tools

Key Benefits for Data Teams

Prerequisites for Census Integration


Setup Guide

Set up Census sync triggering for successful runs. Follow the steps below, and watch our interactive tutorial.

Step 1: Get Your Census Sync URL

  1. Open Census and navigate to your syncs

  2. Find and select the sync you want to trigger

  3. In the Sync Trigger section, copy the API URL

Step 2: Configure the Webhook

  1. From the Bolt home screen, go to Templates

  2. Click Reverse ETL and use the "Trigger Census Sync" template

  3. Enter your Census Sync URL.

Example Sync URL:
https://bearer:secret-token%[email protected]/api/v1/syncs/2511163/trigger
  1. Click "Connect"

Step 3: Test the Integration

  1. Run a Bolt schedule manually (the webhook triggers only on successful runs)

  2. After the run succeeds:

    • From the Bolt homescreen, go to Webhooks

    • Select your Census Sync Webhook

    • Check the Endpoints tab to verify the webhook triggered

Last updated

Was this helpful?