Mixpanel Query Authentication Guide

Mixpanel Query Authentication Guide


Overview

This is a step-by-step guide to acquiring credentials and authorising the Mixpanel Query connector for use in Matillion ETL.

Important Information

  • The Mixpanel Query connector uses an API token for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.

Acquiring Third-Party Credentials

  1. Navigate to the Mixpanel website and click Log In on the right of the header menu. The browser will then redirect to a login screen. Enter valid login credentials to continue.

    Mixpanel homepage

    Mixpanel homepage

  2. The browser will then open on the Insights tab of the Analysis dashboard. In the top right of the screen, click <Account Name>Profile & Preferences.

    Insights on Analysis dashboard

    Insights on Analysis dashboard

  3. On the next page, click Projects on the PERSONAL SETTINGS sidebar on the left. Then, copy the code to the right of API Secret as it will be required in Authorising for use in Matillion ETL.

    Please Note

    When copying the API Secret, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.

    Projects window on Settings page

    Projects window on Settings page


Authorising for Use in Matillion ETL

  1. In Matillion ETL, ensure an Orchestration Job is open on the job canvas. Then, if a Mixpanel Query connector is not already on the job canvas, search "Mixpanel" using the Components search field, or find the Mixpanel Query connector under OrchestrationLoad/UnloadCRM & Marketing Automation, and drag it onto the job canvas.

    Please Note

    An Orchestration Job must be open on the job canvas within Matillion ETL to ensure the Mixpanel Query connector is searchable within the Components panel.

  2. Then, click and drag the Mixpanel Query connector onto the job canvas.

    Search for Mixpanel Query connector

    Search for Mixpanel Query connector

  3. Click the connector icon on the job canvas to open the Properties panel at the bottom of the screen.

  4. Then, click ... next to the API Secret input.

    Open Mixpanel Query connector properties

    Open Mixpanel Query connector properties

  5. In the API Secret pop-up window, paste the API Secret (copied from the Mixpanel website earlier) into the field provided and click OK.

    Paste the API Secret

    Paste the API Secret

  6. If the API Secret is entered correctly, the connector should be authenticated and the status of the input will be displayed as OK.

    Connector successfully authenticated

    Connector successfully authenticated