Skippr Docs

Appearance

Load Data into PostgreSQL Warehouse ​

YAML for this destination lives on the connector page. There is no separate warehouses: block.

PostgreSQL is a powerful open-source database that many teams use as an analytical warehouse. Skippr syncs heterogeneous sources into Postgres schemas you control, with staging and gold models generated for dbt.

CDC is supported on this destination. See CDC destinations.

What Skippr does here ​

  • Extract from 12+ sources directly into PostgreSQL
  • Deterministic schema discovery and evolution
  • Automatic data cleansing with dead letter handling
  • AI business modeling — dimensions, facts, and metrics delivered as dbt
  • Familiar SQL and extensions—run analytics on RDS, Cloud SQL, or self-hosted Postgres

Sample skippr.yml ​

yaml
data_sinks:
  warehouse:
    Postgres:
      host: localhost
      port: 5432
      user: ${POSTGRES_USER}
      password: ${POSTGRES_PASSWORD}
      database: analytics
      schema: public

Full connector reference: postgres.

Install: Install.