Snowplow

Explore the interactive ERD

Table & Field Reference

bad_event

Column	Type	Keys
`id`	String	PK
`event`	String
`reason`	String

custom_context

Column	Type	Keys
`collector_tstamp`	Instant	PKFK
`event_id`	String	PKFK

event

Column	Type	Keys
`collector_tstamp`	Instant	PK
`event_id`	String	PK
`app_id`	String
`br_colordepth`	Int
`br_cookies`	Boolean
`br_family`	String
`br_features_director`	Boolean
`br_features_flash`	Boolean
`br_features_gears`	Boolean
`br_features_java`	Boolean
`br_features_pdf`	Boolean
`br_features_quicktime`	Boolean
`br_features_realplayer`	Boolean
`br_features_silverlight`	Boolean
`br_features_windowsmedia`	Boolean
`br_lang`	String
`br_name`	String
`br_renderengine`	String
`br_type`	String
`br_version`	String
`br_viewheight`	String
`data`	String
`derived_tstamp`	Instant
`doc_charset`	String
`doc_height`	Int
`doc_width`	Int
`domain_sessionid`	String
`domain_sessionidx`	String
`domain_userid`	String
`dvce_created_tstamp`	Instant
`dvce_ismobile`	Boolean
`dvce_screenheight`	String
`dvce_sent_tstamp`	Instant
`dvce_type`	String
`event`	String
`event_format`	String
`event_name`	String
`event_vendor`	String
`event_version`	String
`geo_city`	String
`geo_country`	String
`geo_latitude`	Double
`geo_longitude`	Double
`geo_region`	String
`geo_region_name`	String
`geo_timezone`	String
`geo_zipcode`	String
`mac_address`	String
`mkt_campaign`	String
`mkt_clickid`	String
`mkt_content`	String
`mkt_medium`	String
`mkt_network`	String
`mkt_source`	String
`mkt_term`	String
`name_tracker`	String
`network_userid`	String
`os_family`	String
`os_manufacturer`	String
`os_name`	String
`os_timezone`	String
`page_referrer`	String
`page_title`	String
`page_url`	String
`page_urlfragment`	String
`page_urlhost`	String
`page_urlpath`	String
`page_urlport`	Int
`page_urlquery`	String
`page_urlscheme`	String
`platform`	String
`pp_xoffset_max`	Int
`pp_xoffset_min`	Int
`pp_yoffset_max`	Int
`pp_yoffset_min`	Int
`refr_domain_user_id`	String
`refr_dvce_tstamp`	Instant
`refr_medium`	String
`refr_source`	String
`refr_term`	String
`refr_urlfragment`	String
`refr_urlhost`	String
`refr_urlpath`	String
`refr_urlport`	Int
`refr_urlquery`	String
`refr_urlscheme`	String
`se_action`	String
`se_category`	String
`se_label`	String
`se_property`	String
`se_value`	String
`sequence_number`	String
`ti_category`	String
`ti_currency`	String
`ti_name`	String
`ti_orderid`	String
`ti_price`	String
`ti_quantity`	Double
`ti_sku`	String
`tr_affiliation`	String
`tr_city`	String
`tr_country`	String
`tr_currency`	String
`tr_orderid`	String
`tr_shipping`	String
`tr_state`	String
`tr_tax`	String
`tr_total`	String
`true_tstamp`	Instant
`txn_id`	String
`user_fingerprint`	String
`user_id`	String
`user_ipaddress`	String
`useragent`	String
`v_collector`	String
`v_tracker`	String

ua_parser_context

Column	Type	Keys
`collector_tstamp`	Instant	PKFK
`event_id`	String	PKFK
`device_family`	String
`os_family`	String
`os_major`	String
`os_minor`	String
`os_patch`	String
`os_patch_minor`	String
`os_version`	String
`useragent_family`	String
`useragent_major`	String
`useragent_minor`	String
`useragent_patch`	String
`useragent_version`	String