implementing-warehouse-sources

Implement PostHog Data Warehouse import sources with datasets, endpoints, and incremental sync.

693|111|Updated Aug 11, 2020
One-click install
npx skills add https://github.com/PostHog/posthog-foss --skill implementing-warehouse-sources
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: implementing-warehouse-sources
Source: https://github.com/PostHog/posthog-foss/tree/main/.agents/skills/implementing-warehouse-sources
Command: npx skills add https://github.com/PostHog/posthog-foss --skill implementing-warehouse-sources

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of integrating new data sources into PostHog's Data Warehouse, ensuring seamless data ingestion and management.

Core Features & Use Cases

  • New Source Implementation: Add entirely new data sources to the warehouse.
  • Existing Source Extension: Enhance current sources with new datasets, endpoints, or incremental sync capabilities.
  • Robustness & Reliability: Implement credential validation, pagination, and comprehensive testing for data import pipelines.
  • Use Case: You need to add Stripe as a new data source to sync sales and subscription data into PostHog. This skill guides you through defining the necessary schemas, API interactions, and sync logic.

Quick Start

Use the implementing-warehouse-sources skill to add a new API-backed source for the 'Stripe' platform.

Frequently Asked Questions about implementing-warehouse-sources

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

FAQPage Schema
How do I add a new data source to the PostHog Data Warehouse?

To add a new data source to the PostHog Data Warehouse, define the source configuration, implement the transport logic for API interactions, handle pagination, and validate credentials to enable seamless data ingestion.

How do I implement incremental sync for data warehouse import sources?

Implementing incremental sync for data warehouse import sources involves extending existing source configurations with new endpoints and datasets, ensuring only new or updated records are fetched during each data pipeline execution.

What is needed to integrate an API-backed source for data ingestion?

Integrating an API-backed source for data ingestion requires defining source schemas, implementing REST transport logic to interact with the external API, handling pagination, and validating API credentials for secure data import.

Can I extend existing data warehouse sources with new datasets?

Yes, you can extend existing data warehouse sources by adding new datasets and endpoints to their configurations, enabling broader ETL coverage and supporting incremental sync capabilities for the new data.

How do I test data pipeline sources for API-backed REST integrations?

Testing data pipeline sources for API-backed REST integrations involves writing comprehensive tests that validate credential authentication, verify pagination logic, and ensure the transport layer correctly fetches and maps data warehouse schemas.