I’ll introduce how to create a Data Pipeline to transfer data from Mixpanel to Google BigQuery.

Prerequisites

Mixpanel GROWTH Plan + Data Pipelines Option

1. Upgrade from FREE plan to GROWTH plan
2. Add Data Pipelines option

Create Group in Google Cloud Platform

• Cloud Console でのグループの管理 | Cloud IAM のドキュメント | Google Cloud

I think the easiest management method is to create a group like mixpanel-bigquery@example.com and add a group all@example.com that contains the users you want to grant permissions to.

Steps to Create Pipeline for Data Transfer from Mixpanel to BigQuery

Reference Documents from Mixpanel

The two Mixpanel official documents that were helpful are as follows:

• Export to Data Warehouse
• BigQuery

Create Data Pipeline with Mixpanel API

1. Create Service Account with Authentication Methods
2. Create Pipelines

All unclear points were covered in Data Pipelines FAQ | Mixpanel Community, so I used this as reference.

That’s all from the Gemba on creating a Data Pipeline to transfer data from Mixpanel to Google BigQuery.