Comment on page
Use data sources to connect to the data that matters most for your business.
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.
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.
Select your preferred Sync Engine when connecting a data source.
While your experience of the Census product will be identical either way, there are some important differences between these two options:
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.