Azure Blob Storage

Mixpanel allows you to export events and people data directly into an Azure Blob Storage instance through Json Pipelines.

Setting Blob Storage Permissions

To enable Mixpanel to write data to your Azure Blob Storage, specific permissions need to be set up because Azure authentication mechanisms do not support cross-account access. You will need to provide Mixpanel with Azure credentials linked to your Blob Storage container.

Step 1: Create a Service Principal

Start by creating a Service Principal in your Azure Active Directory. This can be done using the Azure CLI with the following command (with "redacted" output). This command generates credentials in JSON format. Ensure you securely handle the output as it contains sensitive information.

$ az ad sp create-for-rbac --sdk-auth
{
  "clientId": "redacted",
  "clientSecret": "redacted",
  "subscriptionId": "redacted",
  "tenantId": "redacted",
  "activeDirectoryEndpointUrl": "https://login.microsoftonline.com",
  "resourceManagerEndpointUrl": "https://management.azure.com/",
  "activeDirectoryGraphResourceId": "https://graph.windows.net/",
  "sqlManagementEndpointUrl": "https://management.core.windows.net:8443/",
  "galleryEndpointUrl": "https://gallery.azure.com/",
  "managementEndpointUrl": "https://management.core.windows.net/"
}

Step 2: Assign Role to Service Principal

Next, navigate to the Blob Storage container you wish to use, and assign the "Storage Blob Data Contributor" role to the newly created Service Principal.

Step 3: Provide Mixpanel with Access Details

Refer to Step 2: Creating the Pipeline to create data pipeline via UI. You need to provide specific details to enable authentication and data export to Azure Blob Storage. For authentication, supply the Client Id, Client Secret, and Tenant Id. These credentials are crucial for Mixpanel to operate as the Service Principal and ensure secure authentication without exposing broader Azure resources.

Additionally, to define the export destination, you must provide the Storage Account and Container Name. These details identify the exact location within Azure where your data will be exported.