skills.rest
PostHog
PostHogOFFICIAL
Explore all skills by this author →
Website𝕏@PostHogGitHub

setting-up-a-data-warehouse-source

Connect external data warehouse sources to PostHog with per-table sync methods.

58|5|Updated Jan 19, 2026
Search Tags:#credentials#posthog#data-warehouse#data-integration#db-schema#data-sources
One-click install
npx skills add https://github.com/PostHog/skills --skill setting-up-a-data-warehouse-source
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: setting-up-a-data-warehouse-source
Source: https://github.com/PostHog/skills/tree/main/skills/omnibus/setting-up-a-data-warehouse-source
Command: npx skills add https://github.com/PostHog/skills --skill setting-up-a-data-warehouse-source

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Guides users through connecting a new data warehouse source — Postgres, MySQL, Stripe, Hubspot, MongoDB, Salesforce, BigQuery, Snowflake, and so on. Use when the user wants to "connect Stripe", "import data from Postgres", "add a new data source", "sync my warehouse tables", or wants to pick sync methods for each table. Walks through source-type discovery, credential validation, table discovery, per-table sync_type selection, and the final create call. Also covers picking a good prefix and what to do right after creation.

Core Features & Use Cases

  • Supports source-type discovery via an interactive wizard to identify available connectors and required fields.
  • Validates credentials and discovers tables with per-table sync option availability, enabling incremental, append, cdc, webhook, and full_refresh methods.
  • Guides through selecting a descriptive prefix and performing the create call with a properly structured payload, including per-table schemas.
  • Use cases include connecting Stripe to enable webhooks, importing data from Postgres, or syncing tables for analytics workloads.

Quick Start

Connect a new data warehouse source by following the three-step flow (wizard → db-schema → create) to establish the source with validated credentials and a configured schemas payload.

Frequently Asked Questions about setting-up-a-data-warehouse-source

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect a Postgres database to PostHog data warehouse?▼

To connect Postgres to the PostHog data warehouse, use the interactive wizard to validate credentials, discover tables, and select sync methods before finalizing the source creation. This three-step flow establishes a configured schemas payload for your new data source.

What data sources can I sync with PostHog data warehouse?▼

PostHog data warehouse supports syncing external sources like Postgres, MySQL, Stripe, Hubspot, MongoDB, Salesforce, BigQuery, and Snowflake. The connection wizard discovers available connectors and validates required fields to establish the source.

How do I choose a sync method for data warehouse tables?▼

Choosing a sync method for data warehouse tables happens during table discovery, where you can select incremental, append, CDC, webhook, or full_refresh options per table. This configuration step ensures correct data synchronization before the final create call.

Do I need specific credentials to set up a data warehouse source?▼

Yes, setting up a data warehouse source requires validating credentials via an interactive wizard. The wizard identifies required fields for your chosen source type, such as Stripe or BigQuery, ensuring proper authentication before listing available tables.

What is the best way to import data from Stripe into PostHog?▼

The best way to import data from Stripe into PostHog is using the data warehouse source wizard to validate credentials, enable webhooks, and configure per-table sync methods. This structured flow creates a validated source payload for analytics workloads.

Related Skills

Explore More Data & Analytics Skills→
AndreKuraitAndreKurait

connecting-to-data-source

Register and validate AWS Glue connections to external data sources.

Community
Advanced
PostHogPostHog
58

auditing-warehouse-data-health

Audits PostHog warehouse health by surfacing active failures across sources, schemas, views, destinations, and transformations.

Official
Intermediate
PostHogPostHog
58

tuning-incremental-sync-config

Modify data warehouse sync configurations for incremental fields, keys, frequency, and sync types.

Official
Advanced
ThomasRohdeThomasRohde
1

ecm-import-mapper

Maps CSV exports to ECM Studio import artifacts using a mapping JSON.

Community
Intermediate