snowplow-web-data-model icon indicating copy to clipboard operation
snowplow-web-data-model copied to clipboard

Looker: some page view IDs are lost due to deduplication logic in web_page_context

Open tomekzbrozek opened this issue 4 years ago • 0 comments

There's a deduplication logic in this line https://github.com/snowplow/snowplow-web-data-model/blob/faa9f7a19b64c3baf80957fcebfa3f4b669d42f1/looker/web-block-v3/00_scratch_web_page_context.view.lkml#L35 that makes root IDs associated to multiple rows filtered out from the events that are processed further. What's the rationale behind this? Shouldn't the model drop only duplicate values, but keep at least one event per root ID / page view ID?

tomekzbrozek avatar Nov 19 '19 15:11 tomekzbrozek