Back to plugin list
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
2. Create source and destination configs
Plugin configurationOverview #
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 aredfs
(depth-first search),round-robin
,shuffle
andshuffle-queue
.For more information about this, see performance tuning.