Back to plugin list
mixpanel
Official
Premium

Mixpanel

The CloudQuery Mixpanel plugin pulls data from Mixpanel and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v3.7.0

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Set up process #


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync mixpanel.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

The CloudQuery Mixpanel plugin pulls data from Mixpanel and loads it into any supported CloudQuery destination.

Authentication #

In order to fetch information from Mixpanel, cloudquery needs to be authenticated using a Service Account from your Mixpanel account. You can view and manage your Service Accounts in Mixpanel Organization Settings > Service Accounts.

Example Configuration #

kind: source
# Common source-plugin configuration
spec:
  name: mixpanel
  path: cloudquery/mixpanel
  registry: cloudquery
  version: "v3.7.0"
  tables: ["*"]
  destinations: ["postgresql"]
  backend_options:
    table_name: "cq_state_mixpanel"
    connection: "@@plugins.postgresql.connection"
  # Mixpanel specific configuration
  # Learn more about the configuration options at https://cql.ink/mixpanel_source
  spec:
    # required
    username: "${MIXPANEL_SERVICE_ACCOUNT_USERNAME}"
    # required
    secret: "${MIXPANEL_SERVICE_ACCOUNT_SECRET}"
    # required
    project_id: 12345

Configuration Reference #

This is the (nested) spec used by the Mixpanel source plugin:
  • username (string) (required)
    Your Service Account username from Mixpanel.
  • secret (string) (required)
    Service Account secret.
  • project_id (integer) (required)
    ID of the Mixpanel project to sync data from.
  • workspace_id (integer) (optional)
    ID of the Mixpanel workspace to sync data from.
  • start_date (date in YYYY-MM-DD format) (optional)
    Start date to sync data from. Defaults to 30 days ago.
  • end_date (date in YYYY-MM-DD format) (optional)
    End date to sync data until. Defaults to today.
  • region (string) (optional)
    Your Mixpanel region. Defaults to "US". Possible values are "US" and "EU".
  • timeout_secs (integer in seconds) (optional) (default: 30)
    Timeout for requests against the Mixpanel API.
  • max_retries (integer) (optional) (default: 5)
    Number of retries if a request was rate limited at the API endpoint.
  • concurrency (integer) (optional) (default: 10000)
    A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
  • scheduler (string) (optional) (default: dfs) The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.
    For more information about this, see performance tuning.


Join our mailing list

Subscribe to our newsletter to make sure you don't miss any updates.

Legal

© 2024 CloudQuery, Inc. All rights reserved.

We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.