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

• Automatic Census sync triggering after successful Bolt runs

• Real-time data synchronization with operational tools

• Streamlined workflow between dbt™ pipelines and data syncs

• Faster time-to-value for fresh data

Prerequisites for Census Integration

• Existing Bolt schedule
• Census account with configured syncs

• Census Sync Trigger API URL

---

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:[e-mail]/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