MImixpanel
Warehouse Imports

Create a lookup table import

Create a new warehouse import for lookup table data.

Lookup tables allow you to enrich event and user properties with additional attributes from your warehouse.

post/projects/{projectId}/warehouse-sources/imports/lookup-table

Request

Path parameters

projectIdinteger required

Your project id (eg: 12345)

Request body

import_type'lookup_table' required
warehouse_source_idinteger required
table_paramsTableParams required

Table location parameters (structure depends on warehouse type)

property_key_column_namestring required

The name of the column in your warehouse table that contains the join key values. This column's values will be matched against the Mixpanel property specified in mixpanel_property.value to look up the corresponding row.

sync_mode'full_sync' | 'one_time' required
run_every0 | 3600000000000 | 86400000000000 | 604800000000000

Sync frequency in nanoseconds. Only these values are accepted:

  • 0 - API-triggered only (use the manual-sync endpoint to trigger)
  • 3600000000000 - Hourly
  • 86400000000000 - Daily
  • 604800000000000 - Weekly

Response

Success

status'ok'

"ok" if the request succeeded, "error" otherwise.

Example response

{
  "status": "ok"
}

Changes

No recorded changes to this operation across all 1 revision of this API.