snowplow-web-data-model
snowplow-web-data-model copied to clipboard
snowplow
SQL data model for working with Snowplow web data. Supports Redshift and Looker. Snowflake and BigQuery coming soon
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?...
* It'd be great to see a bit more detail in the Readme about the block * We're also now on Looker 6, so references to Looker 4 are a...
The Looker web block contains some Snowplow-specific code, eg: ``` AND a.page_urlhost IN ('snowplowanalytics.com', 'discourse.snowplowanalytics.com') ``` I don't know enough about Looker blocks to know the best way forwards, but...
We can't migrate over PRs from third-parties, but let's create an issue for each PR and leave that open (for now in snowplow/snowplow). Close and de-schedule when done (doesn't go...
`AND a.br_family != 'Robot/Spider'` is a vestige of the deprecated ua parser utils enrichment and causes all page views to be excluded from the view in newer pipelines
While conducting pageview performance analysis on our webpages, we noticed that several pageviews events carried many null values in their information. Further investigating, we came across the condition in the...
Currently the following filter is applied in the `page_views` step of the model ([see SQL](https://github.com/snowplow/web-data-model/blob/master/looker/web-block/page_views.view.lkml#L209): ``` WHERE a.br_family != 'Robot/Spider' ``` The `br_family` field is part of the [user agent...
The tag is web-data-model/1.0.2 but the changelog talks about Release 1, Release 2 etc.