Mixpanel Query Authentication Guide
    • Dark
      Light

    Mixpanel Query Authentication Guide

    • Dark
      Light

    Article Summary

    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


    What's Next