- Source
- Others
- Alpha
Move US Census data anywhere it matters.
Load US Census data into the warehouse or AI app you already run.
Source
US Census
Snowflake
BigQuery
Postgres
Databricks
Claude
- Destinations
- 50+
- Standard support
- 0.4.39
Overview
What is the Airbyte US Census connector?
The Airbyte US Census connector extracts data from US Census and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh. It publishes tables and events you can select per connection.
- 01
Sync to your warehouse
Land US Census data in 50+ destinations on a schedule you control.
- 02
One authorization
Authenticate US Census once and Airbyte keeps every scheduled sync running on it.
- 03
Cloud or self-hosted
Run the US Census connector on Cloud, OSS, Hybrid.
Setup
Live in nine steps
Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
Scroll down until you find the "US Census" source connector and click on it.
Click on the "Create Connection" button to begin setting up your connection to the US Census data source.
In the "Connection Configuration" page, enter a name for your connection and provide your API key in the "API Key" field.
Click on the "Test Connection" button to ensure that your credentials are correct and that the connection is working properly.
Once the connection has been successfully tested, click on the "Create" button to save your connection settings.
You can now use this connection to extract data from the US Census data source by creating a new pipeline and selecting the US Census source connector as your source.
Follow the prompts to configure your pipeline and select the data you want to extract from the US Census data source.
Once your pipeline is configured, you can run it to extract data from the US Census data source and load it into your destination data warehouse or data lake.
Configuration fields
| Field | Type | Description |
|---|---|---|
| api_key* | string | Your API Key. Get your key here. |
| query_path* | string | The path portion of the GET request |
| query_params | string | The query parameters portion of the GET request, without the api key |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
FAQ
US Census connector questions
What data can I sync from US Census with Airbyte?
The US Census connector syncs the tables and events published in Airbyte docs.
Does the US Census connector support incremental sync?
The US Census connector supports full refresh sync. Check the stream list on this page for incremental support per table.
Where can I run the US Census connector?
Run the US Census connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start syncing US Census in minutes.
Free 14-day trial. No credit card needed.