Warehouse Connectors

Import data from external warehouses into Mixpanel

Warehouse Connectors API

Import events, users, groups, and lookup tables from external data warehouses into Mixpanel.

Base URL

https://mixpanel.com/api/app/projects/{projectId}/warehouse-sources/imports

Supported Warehouses

• BigQuery
• Snowflake
• Amazon Redshift
• Databricks
• PostgreSQL

List Warehouse Imports

Get all warehouse imports for a project.

projectId · number · required

Your Mixpanel project ID

Example Request

cURL

curl "https://mixpanel.com/api/app/projects/123/warehouse-sources/imports" \
  -u SERVICE_ACCOUNT_USERNAME:SERVICE_ACCOUNT_SECRET

---

Get Warehouse Import

Get details of a specific import.

projectId · number · required

Your Mixpanel project ID

importId · string · required

The import ID

Example Request

cURL

curl "https://mixpanel.com/api/app/projects/123/warehouse-sources/imports/abc123" \
  -u SERVICE_ACCOUNT_USERNAME:SERVICE_ACCOUNT_SECRET

---

Update Warehouse Import

Pause/resume an import or update its configuration.

projectId · number · required

Your Mixpanel project ID

importId · string · required

The import ID

paused · boolean · required

Pause or resume the import

run_every · integer

Sync frequency in nanoseconds:

• 0: API-triggered only
• 3600000000000: Hourly
• 86400000000000: Daily
• 604800000000000: Weekly

Example Request

cURL

curl "https://mixpanel.com/api/app/projects/123/warehouse-sources/imports/abc123" \
  -X PATCH \
  -u SERVICE_ACCOUNT_USERNAME:SERVICE_ACCOUNT_SECRET \
  -H "Content-Type: application/json" \
  -d '{
    "paused": false,
    "run_every": 86400000000000
  }'

---

Delete Warehouse Import

Delete an import and optionally its imported data.

projectId · number · required

Your Mixpanel project ID

importId · string · required

The import ID

delete_data · boolean

Also delete the imported data from Mixpanel

Default: false

Example Request

cURL

curl "https://mixpanel.com/api/app/projects/123/warehouse-sources/imports/abc123" \
  -X DELETE \
  -u SERVICE_ACCOUNT_USERNAME:SERVICE_ACCOUNT_SECRET \
  -H "Content-Type: application/json" \
  -d '{"delete_data": true}'

Deleting an import with delete_data: true will permanently remove all imported data from Mixpanel.

Best Practices

Start with manual sync

Test your import configuration with manual syncs before enabling scheduled runs.

Monitor import status

Regularly check import status and logs to catch issues early:

def check_import_health(project_id, import_id):
    response = requests.get(
        f'https://mixpanel.com/api/app/projects/{project_id}/warehouse-sources/imports/{import_id}',
        auth=HTTPBasicAuth('USERNAME', 'SECRET')
    )
    
    data = response.json()
    if data['results']['status'] != 'active':
        alert_team(f"Import {import_id} is {data['results']['status']}")

Use appropriate sync frequency

Balance freshness needs with costs:

• Hourly: For real-time critical data
• Daily: For most analytics use cases
• Weekly: For reference/dimension data