Linking Azure as a source

The data warehouse can link to data in your Azure storage accounts.

1. Create an Azure storage account
2. Create a blob container
3. Upload data and link to PostHog

Step 1: Create an Azure storage account

Firstly, log into Azure and go to Storage Accounts, then create a storage account by following this Azure guide.

Step 2: Create a blob container

Once the storage account has been created, follow this guide to create a blob container.

Step 3: Upload data and link to PostHog

Upload your data to the newly created container, Parquet files are the recommended format, but the connector also works with JSON and CSVs too.

Find the newly created file via the storage browser menu item. Once found, open the details and copy URL property. We need it to link the file in PostHog.

1. Go to the Data pipeline page and the sources tab in PostHog
2. Click New source and select Azure from the self managed section
3. Enter a name for your dataset and paste the copied URL into the "Files URL pattern" box
4. Select the correct format for your data
   • When using CSV format, you can configure CSV quote handling to control how quotes are processed:
     • RFC 4180 double quotes – for CSVs that use standard double-quote escaping (e.g., "Hello ""World""" becomes Hello "World")
     • Literal quotes – for CSVs where quote characters are treated as literal values (default)
5. Enter the storage account name (this is name of the storage account you created in step 1)
6. Find and paste your storage account key - you can use this Azure doc to view your access keys

That's it! You should be able to query the data from the PostHog SQL editor.

Configuration

Supported tables

The tables available from this source are discovered from your account when you connect it, so the exact list depends on your data. Once connected, you can pick which tables to sync from the sources tab.