CWV fails on newer snowplow installs due to hard coded context fields

[rlh1994]

Describe the bug

New users only have the 1_0_1 version of yauaa, so the package fails as it can't find the 1_0_0 column. To fix this we need to change the hard coding of the context fields in the CWV this run table e.g.

dbt-snowplow-web/models/optional_modules/core_web_vitals/scratch/bigquery/snowplow_web_vital_events_this_run.sql

Line 41 in e4ae6b2

col_prefix='contexts_nl_basjes_yauaa_context_1_0_0',

Steps to reproduce

Expected results

Actual results

Screenshots and log output

System information

The contents of your packages.yml file:

# contents goes here

Which database are you using dbt with?

• postgres
• redshift
• bigquery
• snowflake
• databricks
• other (specify: ____________)

The output of dbt --version:

<output goes here>

The operating system you're using:

The output of python --version:

Additional context

Are you interested in contributing towards the fix?