Skip to main content

​
Data Pipelines API

The Data Pipelines API allows you to create continuous data pipelines that export your Mixpanel data to external warehouses like BigQuery, Snowflake, S3, and more.

​
Base URL

https://data.mixpanel.com/api/2.0/nessie

​
Authentication

Use Service Account or Project Secret with HTTP Basic Auth.

​
Pipeline Types

​
Raw Exports

Export raw JSON data to cloud storage:
  • Amazon S3: Raw event data to S3 buckets
  • Google Cloud Storage: Raw event data to GCS buckets
  • Azure Blob Storage: Raw event data to Azure containers

​
Schematized Exports

Export structured data to data warehouses:
  • BigQuery: Schematized data to Google BigQuery
  • Snowflake: Schematized data to Snowflake
  • AWS Glue: Schematized data with AWS Glue catalog
  • Azure Synapse: Schematized data to Azure

​
Available Endpoints

​
Pipelines Management

  • List Pipelines: Get all pipelines for a project
  • Create Pipeline: Set up a new data pipeline
  • Edit Pipeline: Modify pipeline configuration
  • Delete Pipeline: Remove a pipeline
  • Pause/Resume Pipeline: Control pipeline execution
View Pipeline Management \u2192

​
Warehouse Connectors

  • List Imports: Get all warehouse imports
  • Create Import: Configure warehouse data imports
  • Update Import: Modify import settings
  • Delete Import: Remove an import
View Warehouse Connectors \u2192

​
Common Parameters

​
project_id
number
required
Your Mixpanel project ID
​
type
string
required
Pipeline type: gcs-raw, s3-raw, azure-raw, bigquery, snowflake, aws, azure-blob, gcs-schema
​
data_source
string
What to export: events or peopleDefault: events
​
from_date
string
required
Start date in YYYY-MM-DD format
​
to_date
string
End date in YYYY-MM-DD format. Leave empty for continuous export.
​
frequency
string
Export frequency: hourly or dailyDefault: daily

​
Quick Start

1

Choose your destination

Decide where you want to export your data (BigQuery, S3, etc.)
2

Create a pipeline

Use the Create Pipeline endpoint with your destination credentials
3

Monitor status

Check pipeline status and sync history
4

Query your data

Access exported data in your warehouse

​
Best Practices

Use trial: true to test with 30 days of data before committing to a full pipeline.
  • Monoschema: All events in one table (easier to query)
  • Multischema: Each event type in its own table (better for large volumes)
Set sync: true to automatically update exported data when changes occur in Mixpanel.
  • Hourly: For real-time analytics needs
  • Daily: For most analytical use cases (more efficient)

Build docs developers (and LLMs) love

Get started for freeTalk to us