Data Warehouse Team

Data Warehouse Team

Somewhere on the slopes of Utah...

People

Recently shipped

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.

Goals

Complete query experience

  • Key Results:
    • SQL copilot
    • BI visualization enhanced
    • Refreshed data warehouse interface

Data Modeling MVP

  • Key Results:
    • Infrastructure decided and implemented
    • Integrating external data with feature flags
    • External data everywhere in insights/persons/cohorts
    • Get billing team to use modeling in posthog for their invoices_with_annual table