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

# Linking Lightdash as a source

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

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

- [Prerequisites](#prerequisites)
- [Adding a data source](#adding-a-data-source)
- [Sync modes](#sync-modes)
- [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 Lightdash connector syncs your BI and analytics data – projects, spaces, dashboards, charts, metrics catalog entries, and organization users – into PostHog's data warehouse. This lets you join Lightdash metadata with the rest of your PostHog data in queries and insights.

## Prerequisites

-   A Lightdash account (Lightdash Cloud or self-hosted) with at least one project.
-   A Lightdash personal access token. Generate one under **Settings** → **Personal access tokens** in Lightdash. The token inherits its owner's project access, so use a token from a user who has access to every project you want to sync.

## Adding a data source

1.  In PostHog, go to the [Sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section.
2.  Click **\+ New source** and click **Link** next to this source.
3.  Enter your credentials (see [Configuration](#configuration) below) and click **Next**.
4.  Select the tables you want to sync, choose a sync method and frequency, then click **Import**.

Once the syncs are complete, you can start querying this data in PostHog.

When linking Lightdash, you need:

-   **Instance URL** – the URL of your Lightdash instance, e.g. `https://app.lightdash.cloud` for Lightdash Cloud or your self-hosted domain. Non-loopback hosts are forced to HTTPS so your token is never sent in cleartext.
-   **Personal access token** – the token you generated from **Settings** → **Personal access tokens** in Lightdash.

The connector validates your credentials by calling the Lightdash API with the token you provide. If your Lightdash instance is self-hosted, make sure it's reachable from the public internet.

## Sync modes

All Lightdash tables sync as **full refresh only**. Lightdash's API doesn't expose server-side timestamp filters, so incremental sync isn't available. Each sync re-downloads every row for the enabled tables.

## Configuration

| Option | Type | Required |
| --- | --- | --- |
| `Instance URL` | text | Yes |
| `Personal access token` | password | Yes |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `projects` | A Lightdash project: one dbt project connected to a warehouse, containing spaces, dashboards, and charts. | Full refresh | — | — |
| `spaces` | A Lightdash space: a folder within a project that groups dashboards and charts, with its own access controls. | Full refresh | — | — |
| `dashboards` | A Lightdash dashboard: a saved collection of charts and other tiles arranged for viewing together. | Full refresh | — | — |
| `charts` | A Lightdash saved chart: a query result visualization that can be added to one or more dashboards. | Full refresh | — | — |
| `metrics_catalog` | An entry in a Lightdash project's data catalog: a metric or dimension field defined in the underlying dbt project, with its usage and ownership metadata. | Full refresh | — | — |
| `org_users` | A member of the Lightdash organization, with their role and account status. | Full refresh | — | — |
| `explores` | A Lightdash explore: a queryable table compiled from a dbt model, with its warehouse location and any compilation errors. Field definitions are not included. | Full refresh | — | — |
| `schedulers` | A Lightdash scheduled delivery: a chart or dashboard sent on a cron schedule to email, Slack, Microsoft Teams, Google Chat, or a Google Sheet. | Full refresh | — | — |
| `scheduler_runs` | One run of a Lightdash scheduled delivery, with its overall status and counts of its child delivery jobs. The API returns runs scheduled in the last 7 days. | Incremental, Full refresh | scheduledTime | — |

## Troubleshooting

-   **"Lightdash rejected your personal access token"** – the token is wrong, expired, or was revoked. Generate a new token under **Settings** → **Personal access tokens** in Lightdash and reconnect.
-   **"Your Lightdash personal access token does not have permission to read this data"** – the token's owner doesn't have access to one or more projects. Check the user's project access in Lightdash and reconnect with a token from a user who has the required permissions.
-   **"The Lightdash instance URL is not allowed"** – the instance URL resolves to an internal or private address. Use your instance's public URL instead.

If your sync is failing or data looks wrong, see the [Data warehouse troubleshooting guide](https://posthog.com/docs/data-warehouse/troubleshooting.md). If that doesn't help, [contact support](https://us.posthog.com/#panel=support%3Asupport%3Adata_warehouse%3A%3Atrue) – we're happy to help.