Mixpanel Query authentication guide

This guide covers acquiring credentials and authorizing the Mixpanel Query connector for use in Matillion ETL.

Note

• 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. Enter your login credentials to continue.

   

2. Click <Account Name> → Profile & Preferences in the top right of the Analysis dashboard.

   

3. Click Projects in the PERSONAL SETTINGS section on the left. Copy the API Secret value—you need this in Authorizing for use in Matillion ETL.

   Note

   When copying the API Secret, some browsers may add a space to the end of the code. This will cause the credentials to fail.

   

---

Authorizing for use in Matillion ETL

1. In Matillion ETL, ensure an orchestration job is open on the job canvas.
2. Search for the Mixpanel Query connector using the Components search field, or navigate to Orchestration → Load/Unload → CRM & Marketing Automation.
3. Drag the Mixpanel Query connector onto the job canvas.
4. Click the connector icon on the job canvas to open the Properties panel.
5. Click ... next to the API Secret input.
6. In the API Secret dialog, paste the API Secret into the field and click OK.
7. Confirm the API Secret status displays as OK.