Data warehouse

All your data in one place

Unify and query data from any source and analyze it alongside your product data.

Screenshot of the PostHog data warehouse
  • analyzes Google Adwords data in PostHog

    "I needed one source of truth for both marketing and developers to share."

    Read the story
  • syncs Intercom messages and customer contacts

    "PostHog is the single source of truth for us. We've put everything in one place."

    Read the story

Features

  • Sync from Stripe

    Combine financial and product data to see how usage turns into growth.

  • Sync from Hubspot

    Bring your CRM into the mix and track your sales funnel directly in PostHog.

  • Sync from Zendesk

    See how ticket volumes and SLA breaches impact sign-ups and churn.

  • Sync from anywhere

    Adwords? Salesforce? Grab anything you want using custom sources.

  • Link multiple sources

    Add joins to link tables together and connect run advanced queries

  • Query with HogQL

    Use our take on SQL to interrogate data and build custom queries

  • Save queries as views

    Save time by saving visualized data as tables, graphcs, and more

  • Custom sync periods

    Decide whether to sync data sources daily, weekly, or monthly

Usage-based pricing

Use the data warehouse for free up to 1 million rows/mo.

Just another hedgehog

Free

No credit card required

All other plans

All features, no limitations

Rows

1,000,000/mo

Unlimited

Features

One-click integrations
Included
Included
Custom views
Included
Included
Direct linking
Included
Included
Cross-source joins
Included
Included
Unified querying
Included
Included
Data visualization
Included
Included
Incremental sync
Included
Included
Sync frequency
Included
Included

Monthly pricing

First 1 million rows
Free
1-10 million
$0.000015/row
10-100 million
$0.000010/row
100 million+
$0.000008/row

FAQs

Featured tutorials

Visit the tutorials section for more.

  • How to set up Stripe reports

    Analyze gross revenue, customer counts, MRR, churn, and more

    Read more
  • How to set up Hubspot reports

    Monitor deal counts, lead ratings, and identify leads by pageview behaviours.

    Read more
  • How to set up Zendesk reports

    Track ticket counts, power users, SLA metrics, and more.

    Read more

Explore the docs

Get a more technical overview of how everything works in our docs.

Meet the team

PostHog works in small teams. The Data Warehouse team is responsible for building the data warehouse.

Roadmap & changelog

Here’s what the team is up to.

Latest update

Sep 2024

Azure SQL now available as a data source

You can now link your database tables from an Azure SQL server, to PostHog's data warehouse. In fact, you can connect any Microsoft SQL server, because we use Microsoft ODBC 18 to connect to your SQL server.

There are some caveats. For Azure databases, we can only use SQL authentication and the database needs to be publicly accessible, or use an SSH tunnel. This should all be easily done, however. We explain it all in the docs, of course.

Up next

Check out the company roadmap to see what we're working on next!

Questions?

See more questions (or ask your own!) in our community forums.

  • Question / Topic

Pairs with...

PostHog products are natively designed to be interoperable using Product OS.

This is the call to action.

If nothing else has sold you on PostHog, hopefully these classic marketing tactics will.

Eco-friendly

PostHog Cloud

Digital download*

PostHog Cloud
People on G2 think we're great

Notendorsed
by Kim K

*PostHog is a web product and cannot be installed by CD.
We did once send some customers a floppy disk but it was a Rickroll.

  • Select your cloud
  • Starts at:
    $0Free>1 left at this price!!

Hurry: Tons of companies signed up . Act now and get $0 off your first order.