> ## Documentation Index
> Fetch the complete documentation index at: https://docs.labelbox.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Census integration

> Shows how to set up a Census integration to connect remote data to Labelbox, including relational databases (RDBMS), data warehouses, data lakes, and more.

<Warning>
  ### Sunsetted feature

  **Census integration** is no longer supported as of June 30, 2025.
</Warning>

You can set up a Census integration to load remote data into your Labelbox datasets from various sources, including:

* Data warehouses such as Databricks, BigQuery, and Snowflake
* Storage buckets such as GCP, AWS, and Azure
* Databases such as MySQL and Postgres

<Info>
  ### Census availability

  The Census integration feature is available exclusively for paid customers. Free users need to upgrade their subscription to access this feature. For more information on upgrading your subscription, please see [Plans & pricing](https://labelbox.com/pricing/).
</Info>

<Frame>
  <img src="https://mintcdn.com/labelbox-1db23ff4/lnhxZSTssM0QD0kK/images/docs/bc6003a-census-labelbox-workflow-diagram.png?fit=max&auto=format&n=lnhxZSTssM0QD0kK&q=85&s=2949cb89d4c4d24cd54decff444a2fcd" width="800" height="150" data-path="images/docs/bc6003a-census-labelbox-workflow-diagram.png" />
</Frame>

## Data requirements

Each entry in your data must have the following values for a successful integration:

* A *global key* that uniquely identifies individual data rows. Global keys (also called sync keys) help Labelbox distinguish between new records, changed records, or duplicate records. Global keys must be unique within your Labelbox workspace, generally an organization subscription.
* A *dataset ID* that identifies the data row destination. You can specify the dataset ID in the source data or as a constant value when setting up the sync. To find a dataset ID, use **Catalog** to open the dataset and then use the Dataset menu to copy the dataset ID to the Clipboard.
* A *row data* value that specifies the location of a data asset.

You can also include the following additional fields:

* A *Metadata* JSON object (*dictionary*) that specifies custom metadata to be added to the data row. A [size limit](/docs/limits#schema) applies based on your subscription. Example: `[{ "name": "dog", "value": 123 }, { "name": "fox", "value": 123 }]`
* An *Attachments* JSON object that specifies attachments to be associated with the data row. Example:
  ```json theme={null}
  [
    {
      "type": "RAW_TEXT",
      "value": "IOWA, Zone 2232, June 2022 [Text string]"
    },
    {
      "type": "IMAGE",
      "value": "https://storage.example.com/samples/attachment.jpeg"
    }
  ]
  ```

See this [Google Sheet](https://docs.google.com/spreadsheets/d/1Au3grmCTg7gvTlriTZTmB9bbUWnqkidSG8cWJ0DSaRw/edit?usp=sharing) for an example on how to structure required and optional values.

## Add integration

To add an integration between a data source and Labelbox:

1. Navigate to **Settings** > [Integrations](https://app.labelbox.com/workspace-settings/integrations).
2. To add a new integration, select **Sync from a source**.
3. Select the data source that you want to connect to Labelbox.
4. Follow the instructions to configure your integration settings.

You can check the connection status of your configured integrations under **Manage integrations** and start to sync integrated data to your datasets.

## Sync integration to dataset

To sync data on an integrated data source to a dataset:

1. On the **Workspace settings** page, select [Integrations](https://app.labelbox.com/workspace-settings/integrations).
2. Under **Manage integrations**, select **Sync Integration**.
3. Select an existing dataset or create a new dataset for loading in your data.
4. Under **Select a Source**, select **Select a Warehouse Table**. Then, under **Connection**, select your integration source.
5. Keep the default settings of **Select a Destination**.
6. Under **Select a Sync Behavior**, select the data operation type that controls how data rows are imported into Labelbox. The options are **Create only**, **Update only**, **Update or Create**, and **Delete**.
7. Map your data according to the [data requirements](#data-requirements).
8. (Optional) Run a test sync to verify the sync behavior.
9. Select a **Run Mode** to manually trigger the sync or set up a pattern that automates the data sync between your source and Labelbox.

Once your sync has run successfully, you can manage and use your dataset with synced data like any other Labelbox dataset.