# Census integration

> Reverse ETL / data activation platform — sync data from your warehouse to SaaS destinations and manage syncs, sources, destinations, and datasets via the Management API.

- Authentication: apiKey

## Tools (19)

- **Create Dataset**: Create a new SQL-defined dataset attached to an existing source connection.
- **Create Destination**: Create a new destination connection (CRM, marketing tool, etc.) in the workspace.
- **Create Source**: Create a new data source connection (warehouse/database) in the workspace.
- **Create Sync**: Create a new sync wiring a source object to a destination object with field mappings.
- **Fetch Dataset**: Get full definition (SQL query, source, columns) of a single dataset.
- **Fetch Destination**: Get full configuration, supported object types, and connection test results for one destination.
- **Fetch Source**: Get full configuration and last-test results for a single source connection.
- **Fetch Sync**: Get full configuration for a single sync by ID.
- **Fetch Sync Run**: Get status and record counts for a single sync run (use to poll after Trigger Sync Run).
- **List Datasets**: List all datasets (SQL-defined data models) in the workspace. Datasets replace the deprecated Models endpoint.
- **List Destination Object Types**: List the object types a destination service (e.g. hubspot, salesforce) supports — useful before creating a sync.
- **List Destinations**: List all destination connections (CRMs, marketing tools, etc.) in the workspace.
- **List Models**: List models (deprecated SQL data models) for a given source. Prefer the Datasets endpoints for new code.
- **List Sources**: List all data source connections (warehouses, databases, etc.) in the workspace.
- **List Sync Runs**: List recent runs of a specific sync with status, record counts, and error details.
- **List Syncs**: List all syncs configured in the workspace, with pagination.
- **Trigger Sync Run**: Start a one-off run of a sync immediately. Returns the new sync_run_id which you can poll via Fetch Sync Run.
- **Update Dataset**: Update a dataset's name, description, or SQL query.
- **Update Sync**: Patch a sync's configuration. Pause/unpause, adjust schedule, change mappings, or rename.

## Related prompts

- [Weekday Census sync health digest for your data ops channel](https://www.generalinput.com/prompts/weekday-census-sync-health-digest-for-your-data-ops-channel.md)
- [Triage failed Census syncs to PagerDuty, Linear, and Slack](https://www.generalinput.com/prompts/triage-failed-census-syncs-to-pagerduty-linear-and-slack.md)
- [Weekly Census sync activity report for leadership](https://www.generalinput.com/prompts/weekly-census-sync-activity-report-for-leadership.md)
- [Pre-warm Census syncs before the sales day starts](https://www.generalinput.com/prompts/pre-warm-census-syncs-before-the-sales-day-starts.md)

Connect Census in General Input: https://www.generalinput.com/apps/census