> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt

# Linking Census as a source

Canonical URL: https://posthog.com/docs/data-pipelines/sources/census

> **Cloud region:** This page uses US Cloud hosts. For an EU Cloud project, use `https://eu.posthog.com` instead of `https://us.posthog.com` or `https://app.posthog.com` (app host for links).

## On this page

- [Adding a data source](#adding-a-data-source)
- [Getting your API access token](#getting-your-api-access-token)
- [Configuration](#configuration)
- [Supported tables](#supported-tables)
- [Sync modes](#sync-modes)
- [Available tables](#available-tables)

**Beta release**

This source is currently in **beta**. It works end to end, but you may still hit rough edges. [Let us know](https://us.posthog.com/#panel=support%3Asupport%3Adata_warehouse%3A%3Atrue) if you do.

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

`npx @posthog/wizard warehouse`

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

![](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)Let AI connect your sources for you

The Census (Fivetran) connector syncs your reverse-ETL workspace metadata into PostHog, including syncs, sync runs, sources, destinations, and datasets. New sources use the Fivetran Activations API V2, which requires an Activations personal access token.

**Activations API V1 retiring on January 15, 2027**

Fivetran is retiring the Activations API V1 on January 15, 2027. Existing V1 sources continue to work until then, but you should migrate to V2 before the sunset. To migrate, create an Activations personal access token in your Fivetran user settings and set up a new Census source in PostHog with it.

## Adding a data source

1.  Go to the [Data pipeline page](https://app.posthog.com/data-management/sources) and select the **Sources** tab.

2.  Click **\+ New source** and select **Census (Fivetran)** by clicking the **Link** button.

3.  Select your **Workspace region** from the dropdown:

| Label | Connects to |
| --- | --- |
| US | `app.getcensus.com` |
| EU | `app-eu.getcensus.com` |

4.  Enter your **API access token**. New sources require an Activations personal access token (see [Getting your API access token](#getting-your-api-access-token) below).

5.  Click **Next**.

6.  Select the tables you want to import, set the sync method and frequency, then click **Import**.

The data warehouse then starts syncing your Census data. You can see details and progress in the [data pipeline sources tab](https://app.posthog.com/data-management/sources).

## Getting your API access token

New Census sources use the Activations API V2, which requires an Activations personal access token:

1.  Log in to your Fivetran account.

2.  Go to your Activations **User settings** > **Personal access tokens**.

3.  Create a new personal access token.

4.  Copy the token – you'll need it when linking the source in PostHog.

Activations personal access tokens are separate from Fivetran API keys and Fivetran personal access tokens.

## Configuration

| Option | Type | Required |
| --- | --- | --- |
| `API access token` | password | Yes |
| `Workspace region` | select | Yes |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `syncs` | A Census sync: the configuration that moves data from a source model to a destination object, including its schedule, field mappings, and alerting. | Full refresh | — | — |
| `sync_runs` | A single execution of a Census sync, including its status, timing, and per-run record counts. | Full refresh | — | — |
| `sources` | A Census data source: a connected warehouse or database Census reads records from. | Full refresh | — | — |
| `destinations` | A Census destination: a connected SaaS tool or warehouse Census writes records to. On API V2 each row is an activation, which pairs a source connection with the service it writes to. | Full refresh | — | — |
| `datasets` | A Census dataset: the SQL query against a source connection that defines the records a sync reads. | Full refresh | — | — |

## Sync modes

All Census tables use full refresh. Census's API does not expose a server-side filter for update time, so incremental syncing is not available.

| Table | Sync method |
| --- | --- |
| `syncs` | Full refresh |
| `sync_runs` | Full refresh |
| `sources` | Full refresh |
| `destinations` | Full refresh |
| `datasets` | Full refresh |
| `workspaces` | Full refresh |

**Full refresh** syncs reload all data on each run.

## Available tables

| Table | Description |
| --- | --- |
| `syncs` | Census sync configurations that move data from a source model to a destination object, including schedule, field mappings, and alerting. |
| `sync_runs` | Execution records of Census syncs, including status, timing, and per-run record counts. |
| `sources` | Data sources connected to Census – warehouses or databases that Census reads from. |
| `destinations` | Destinations connected to Census – SaaS tools or warehouses that Census writes to. |
| `datasets` | Datasets configured in Census. |
| `workspaces` | Workspaces in your Census organization. Only available on legacy V1 sources – V2 does not include this table. |

**Sensitive fields are stripped**

The `connection_details` field is automatically removed from the `sources` and `destinations` tables. This field contains warehouse account identifiers (account name, user, warehouse name) that shouldn't be accessible to all project members.

On V2 sources, the `notification_emails` and `storage_backend` fields are also removed from the `sources` table.