How to Create a Data Pipeline to Transfer Data from Mixpanel to Google BigQuery

Tadashi Shigeoka ·  Thu, August 19, 2021

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

Data Pipeline 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

I think the easiest management method is to create a group like [email protected] and add a group [email protected] 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:

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.