Configuring Mixpanel connections - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Configuring Mixpanel connections

Mixpanel supports username and password for BasicAuth. Basic Authentication is a simple authentication method where clients provide credentials directly to access protected resources. Amazon Glue is able to use the username and password to authenticate Mixpanel APIs.

For public Mixpanel documentation about BasicAuth flow, see Mixpanel Service Accounts .

To configure a Mixpanel connection:

  1. In Amazon Secrets Manager, create a secret with the following details:

    • For Basic Authentication, Secret should contain the connected app Consumer Secret with USERNAME and PASSWORD as key.

      Note

      It is a must to create a secret per connection in Amazon Glue.

  2. In the Amazon Glue Studio, create a connection under Data Connections by following the steps below:

    1. When selecting a Connection type, select Mixpanel.

    2. Provide the INSTANCE_URL of the Mixpanel that you want to connect to.

    3. Select the IAM role for which Amazon Glue can assume and has permissions for the following actions: 

      {
"Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "secretsmanager:DescribeSecret",
                "secretsmanager:GetSecretValue",
                "secretsmanager:PutSecretValue",
                "ec2:CreateNetworkInterface",
                "ec2:DescribeNetworkInterface",
                "ec2:DeleteNetworkInterface",
            ],
            "Resource": "*"
        }
    ]
}

    4. Select the secretName which you want to use for this connection in Amazon Glue to put the tokens.

    5. Select Network options if you want to use your network.

  3. Grant the IAM role associated with your Amazon Glue job permission to read secretName.