Query & visualize product and third party data together

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

Customers who love PostHog's Data Warehouse

Features

• Query with PostHog SQL: Directly access your data, join sources, and interrogate data however you want
  • Add queries to notebooks: Use PostHog notebooks to collect warehouse info, research topics, or just as a scratch pad
  • Save queries as views: Visualize your results as tables, graphs, and more, then save them for easy access
  • Write SQL without knowing SQL: Nobody likes writing SQL, except for our AI helper, Max
  • Simplified syntax: Access properties with dot notation like properties.$browser
  • Smart joins: Automatic joins between events, persons, and groups
  • Product functions: Built-in functions for cohorts, feature flags, and more
  • ClickHouse power: Full access to ClickHouse functions and performance
  • Time zone handling: Automatic time zone conversion for your project
• SQL insights: Build any analysis with SELECT, JOIN, WHERE, GROUP BY and visualize results in multiple formats.
  • Complex queries: Multi-step CTEs, window functions, and subqueries
  • Multiple visualizations: Tables, line charts, bar charts, and more
  • Save & share: Save queries as insights to add to dashboards
  • Export results: Download query results as CSV or JSON
  • Query templates: Start from examples or save your own templates
• Hog:
  • SQL-compatible syntax: If you know SQL, you already know most of Hog. Built to feel natural for data analysis.
  • Real-time destinations: Build custom destinations that process and route your data in real-time.
  • Secure execution: The HogVM provides a secure sandbox for running user-provided code at scale.
• Data exploration: Explore events, persons, sessions, and external data sources with schema browser and auto-complete. Visualize your data warehouse data using tables, trends, and more. You can also use data warehouse data with insights.
  • Schema browser: See all tables, columns, and data types
  • Auto-complete: IntelliSense for tables, columns, and functions
  • Sample data: Preview table contents before querying
  • Query history: Access and rerun previous queries
  • Performance hints: Optimization suggestions for slow queries
• External data sources: Join events with data from Stripe, HubSpot, databases, and more in a single query.
  • Data warehouse: Connect external sources like Stripe, HubSpot, and databases
  • Unified queries: JOIN PostHog events with external tables
  • Custom views: Save data as views to reuse in other queries. Materialize them to improve performance
  • Scheduled syncs: Keep external data fresh with automatic updates
  • S3 & BigQuery: Query data directly from cloud storage
• SQL API: Query PostHog data from your applications, notebooks, or BI tools via API.
  • REST API: Simple HTTP endpoints for SQL queries
  • Authentication: Secure access with personal API keys
  • Structured responses: JSON results with types and metadata
  • Python & JS SDKs: Native libraries for common languages
  • BI tool integration: Connect Tableau, Looker, and other tools
• Variables: Use variables to customize queries for different users, customers, timeframes, and other filters.
• Sync from anywhere: Stripe, Hubspot, Zendesk, Adwords, Salesforce, and major databases.
• Person joins: Join warehouse data on PostHog persons to easily access that data wherever you access the person profile.
• Combine PostHog data with other sources: Combine your product data with revenue, CRM, logs, and much more to get a full picture of your business.
• Connectors: Use Temporal to sync data from your sources into PostHog's S3 storage smoothly. We'll handle the data flow for you.

Common questions

• How do specific user behaviours correlate to MRR?
• How is user retention affected by SLA breaches in Zendesk?
• How are inbound leads using my product?
• How does predicted revenue compare to my actual revenue?
• How much revenue am I churning each month?
• Who are my power users, and how do they use my product?

Works great with

• Product analytics: Analyze data from any source independently, or alongside product data.
• Feature flags: Use synced data to toggle feature flags, trigger A/B experiments, and more.
• Experiments: You can use data warehouse data as primary or secondary metrics in experiments.
• Docs/sql: Create entirely custom queries, join sources, and get the answers you need.