Supernova home
Documentation menu

Mixpanel#

Connect Mixpanel with service-account credentials and a project id. The source writes 4 fixed tables under titan.mixpanel.

sql
select
  insert_id,
  event,
  distinct_id
from titan.mixpanel.events
limit 10

Connect Mixpanel#

  1. Open Apps, choose Connect app, and select Mixpanel.

  2. Enter service-account credentials and a project id.

  3. Review the tables, then save the source.

  4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Configure the initial sync date and late-arrival lookback so delayed events are refreshed without rereading all history.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

events#

titan.mixpanel.events has 5 source columns.

mixpanel.events5 columns
insert_idstringpk

Source field insertId.

eventstring

Source field event.

distinct_idstring

Source field distinctId.

timedatetime

Source field time.

propertiesjson

Source field properties.

profiles#

titan.mixpanel.profiles has 2 source columns.

mixpanel.profiles2 columns
distinct_idstringpk

Source field distinctId.

propertiesjson

Source field properties.

cohorts#

titan.mixpanel.cohorts has 4 source columns.

mixpanel.cohorts4 columns
idintegerpk

Source field id.

namestring

Source field name.

descriptionstring

Source field description.

createddatetime

Source field created.

funnels#

titan.mixpanel.funnels has 2 source columns.

mixpanel.funnels2 columns
funnel_idintegerpk

Source field funnelId.

namestring

Source field name.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.