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

# Linking Crunchbase as a source

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

> **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

- [Requirements](#requirements)
- [Adding a data source](#adding-a-data-source)
- [Available tables](#available-tables)
- [Sync behavior](#sync-behavior)
- [Configuration](#configuration)
- [Supported tables](#supported-tables)
- [Troubleshooting](#troubleshooting)

**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 Crunchbase connector syncs company, funding, and investment data from Crunchbase into PostHog, including organizations, people, funding rounds, acquisitions, investments, IPOs, and funds.

**Crunchbase Enterprise or Applications license required**

The Crunchbase Search API requires a **paid Enterprise or Applications license** from Crunchbase. A Basic-plan API key returns a 403 error and is rejected at connection time. Check the [Crunchbase pricing page](https://about.crunchbase.com/products/) for details on eligible plans.

## Requirements

Before you begin, you need:

-   A Crunchbase account with an **Enterprise** or **Applications** license
-   A Crunchbase API user key (found in your [Crunchbase account integrations](https://www.crunchbase.com/account/integrations/crunchbase-api))

## Adding a data source

1.  Go to the [Data pipeline page](https://app.posthog.com/data-management/sources) and the **Sources** tab in PostHog.
2.  Click **\+ New source** and select Crunchbase.
3.  Enter your Crunchbase **User key**.
4.  *Optional:* Add a prefix to your table names.
5.  Click **Next**.

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

## Available tables

| Table | Description |
| --- | --- |
| `organizations` | Company data including description, website, founding date, categories, location, total funding, employee count, and operating status |
| `people` | Individual profiles with first and last names |
| `funding_rounds` | Funding round details including announcement date, investment type, money raised, funded organization, and investor count |
| `acquisitions` | Acquisition events with announcement date, acquirer, acquiree, and price |
| `investments` | Individual investment records with announcement date, investor, funding round, and amount invested |
| `ipos` | IPO events including public date, stock symbol, money raised, and valuation |
| `funds` | Investment fund details with announcement date, money raised, and fund name |

All tables use `uuid` as the primary key.

## Sync behavior

All Crunchbase tables support **incremental syncing** on the `updated_at` field. During incremental syncs, PostHog queries Crunchbase for records where `updated_at` is greater than or equal to the last synced value, so only new and modified records are fetched.

Data is partitioned by the `created_at` field using monthly partitions.

## Configuration

| Option | Type | Required |
| --- | --- | --- |
| `User key` | password | Yes |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `organizations` | A company or organization profile in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `people` | A person profile in Crunchbase, such as a founder, executive, or investor. | Incremental, Full refresh | updated\_at | — |
| `funding_rounds` | A funding round raised by an organization in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `acquisitions` | An acquisition of one organization by another in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `investments` | An investment made by an investor into a funding round in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `ipos` | An initial public offering (IPO) by an organization in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `funds` | A fund raised by an investment firm in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `jobs` | A role held by a person at an organization in Crunchbase, past or present. | Incremental, Full refresh | updated\_at | — |
| `categories` | An industry category that organizations are tagged with in Crunchbase. | Incremental, Full refresh | updated\_at | — |
| `category_groups` | A broad industry grouping that Crunchbase categories roll up into. | Incremental, Full refresh | updated\_at | — |
| `locations` | A place in the Crunchbase location hierarchy, such as a city, region, or country. | Incremental, Full refresh | updated\_at | — |
| `ownerships` | A parent/subsidiary relationship between two organizations in Crunchbase. | Incremental, Full refresh | updated\_at | — |

## Troubleshooting

### 403 Forbidden error at connection time

The Crunchbase Search API requires an Enterprise or Applications license. If you're using a Basic-plan API key, Crunchbase returns a 403 error and PostHog rejects the key at connection time. Upgrade your Crunchbase plan to a tier that includes Search API access.

### 401 Unauthorized error

Your API user key is invalid or has been revoked. Generate a new key from your [Crunchbase account integrations](https://www.crunchbase.com/account/integrations/crunchbase-api) and update the source configuration in PostHog.