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 SQL

    Directly access your data, join sources, and build custom queries

  • Save queries as views

    Save time by saving visualized data as tables, graphics, 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

Apr 2025

SQL variables now available

You can now use SQL variables in queries, enabling you to create configurable, reusable elements by defining placeholders that can be dynamically replaced with the desired value.

This makes it super easy to do things like compare user behaviour before and after specific dates, for example. You just run the query below and the UI will now ask you to provide the variables start_date, launch_date, and end_date - and you can just reuse the query for any launch by changing the date without having to rewrite the SQL.

SELECT
CASE
WHEN timestamp < {variables.launch_date} THEN 'Before Launch'
ELSE 'After Launch'
END AS period,
count() as completions
FROM events
WHERE event = 'onboarding_complete'
AND timestamp BETWEEN {variables.start_date} AND {variables.end_date}
GROUP BY period
ORDER BY completions DESC

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

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.