Overview
Use data sources to connect to the data that matters most for your business.
Last updated
Use data sources to connect to the data that matters most for your business.
Last updated
Source data for all Census Syncs come from your data warehouse. Historically, a data warehouse was the end of the line, where data went to collect dust. But modern cloud data warehouses enable a huge variety of data sources and data size, as well as the flexibility to define how data should be aggregated, joined, and organized specifically for your business. It's this flexibility and scalability that make it the perfect data hub for your operations.
At Census, we refer to Data Sources as exactly that—the data warehouse or database that is used as the single source of truth within your organization.
The menu to the left lists all of the data sources that Census currently supports. If you don't see your data source listed, please let us know!
Census offers two methods of connecting to your data source and keeping track of what's been synced (a.k.a. "state tracking"). We call these Sync Engines. When connecting a data source for the first time, we'll ask you to select either Basic or Advanced Sync Engine.
While your experience of the Census product will be identical either way, there are some important differences between these two options:
| Basic Sync Engine | Advanced Sync Engine | |
|---|---|---|
State tracking location | Census infrastructure | Your data warehouse |
Sync performance | Slower | Faster |
Ease of setup | Very easy | Slightly more involved |
Warehouse permissions | Read-only access | Read/write access |
Ability to switch | Ability to upgrade to advanced (coming soon) | Not possible to downgrade to basic |
Some data sources (e.g. Google Sheets and Elasticsearch) only support Basic Sync Engine since writing state back to them is either challenging or impossible.
If you have any questions about which Sync Engine is right for you, please reach out to our support team.
Most sources require allowlisting IP Addresses so that Census's systems can unload data from the source. BigQuery and Databricks are notable exceptions, so do check the source-specific docs if you have any questions.
If your source is protected by a firewall, please add Census's IP addresses to the allowlist. You can find Census's set of IP address for your region in Regions & IP Addresses.
