I am busy modelling events of a signup funnel using custom events.
events table in Redshift. On the modelling side, I intended to apply something close to web-data-model, for
struct events instead of
In the scope of that, I discovered that in the table
com_snowplowanalytics_snowplow_web_page_1, there are per
events.event_id. It looks to me that the relation
event_id is 1:1 for page_view events only, but all other events (
struct) are assigned to the same
id. I suppose that these are happening in the same page_view and therefore are bundle under the same
id, correct?! (or is not intended)?
If intended, is there another approach to deduplicate the structured events (without partitioning over
id, se_category, se_action, se_label and by this approach potentially filtering intended multiple
struct events within the same session/page_view (of e.g. a Single Site Application)?
Thanks for your feedback,