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
Open Census and navigate to your syncs
Find and select the sync you want to trigger
In the Sync Trigger section, copy the API URL

Step 2: Configure the Webhook
Click Reverse ETL and use the "Trigger Census Sync" template
Enter your Census Sync URL.
https://bearer:secret-token%[email protected]/api/v1/syncs/2511163/trigger
Click "Connect"

Step 3: Test the Integration
Run a Bolt schedule manually (the webhook triggers only on successful runs)
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?