The data warehouse in PostHog Web

The PostHog web app is home base for the data warehouse. It's where you link sources, watch them sync, write SQL across everything at once, save the useful queries as views, and turn the results into insights the rest of your team can read.

Open the SQL editor to see the schema browser: your PostHog tables, every synced source table, and your saved views, all queryable together. It's also the only surface where you can change a view's SQL, because a view's definition lives in PostHog rather than in your repository.

What you can do here

• Link sources – connect Stripe, Postgres, Salesforce, HubSpot, and dozens more, pick which tables to sync, and re-run or reset a table when a sync goes wrong.
• Query with SQL – run HogQL against your events, persons, and sessions alongside every synced source table.
• Join data across sources – connect a source table to your PostHog data so product and business data answer the same question.
• Create views – save a query as a view and reference it from other queries.
• Materialize views – refresh a view on a schedule instead of recomputing it on every read.
• Visualize with insights – turn any query into a SQL insight and put it on a dashboard.
• Fix a query with PostHog AI – when a query in the SQL editor errors, PostHog AI can repair it with your real schema in context. It's an interaction mode inside the SQL editor, not a separate surface, and it's the only place PostHog AI touches the warehouse.

Related

• Start with Get started with the data warehouse.
• Run the same queries from your editor over MCP.
• Automate the same work with the API.
• Work through failing models and syncs in PostHog Desktop.
• Point psql, Metabase, or any Postgres driver at your managed warehouse.
• Check troubleshooting when a query or sync misbehaves.