Query your data warehouse

Last updated:

|Edit this page

The PostHog data warehouse is accessed through SQL insights.

Managing your data sources

You can find your data sources in the Data Warehouse tab. On this page, you can view your PostHog generated tables and fields. You can also create, manage, view and delete external tables and their related fields.

data warehouse external tab

Questions?

Was this page useful?

Next article

Creating views

In the PostHog data warehouse, you can save your most used queries as views and reference them in subsequent queries. Creating a view Query views are created directly inside SQL insights. If the query has valid view characteristics, the "Save as view" button is enabled. When clicked, you are prompted to give the view a name which can then be referenced in other queries. For a query to be a valid view, all fields being accessed must be aliased (with the SQL as keyword). The alias names are…

Read next article