search

snowplow / snowplow-web-data-model

SQL data model for working with Snowplow web data. Supports Redshift and Looker. Snowflake and BigQuery coming soon
61 stars 31 forks source link

Looker: address Snowplow-specific code #41

Open alexanderdean opened 5 years ago

alexanderdean commented 5 years ago

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 some options might be:

  1. Delete the Snowplow-isms
  2. Parameterise the Snowplow-isms (assuming Looker supports parameters)
  3. Write some documentation explaining how to manually edit the block and change the Snowplow-isms to values that make sense for you
carabaestlein commented 4 years ago

I would go for option 1!