Snowplow-web 0.4.1 dbt package released

We are very happy to announce the release of the snowplow-web v.0.4.1 dbt package.

This patch release fixes a bug whereby long unexpired sessions can result in duplicates in some tables. In addition for Redshift users all views in the package are now set to be late binding.

Fixes

  • Fix for unexpired sessions (#47)
  • Update all views in Redshift to late binding. This removes any potential dependency between the view and any source Snowplow tables referenced by the view. Without removing this dependency, the source table schemas are unable to be altered (#48)

Upgrading

To upgrade bump the version of the package in your packages.yml file.

While these fixes will be automatically applied, if you have experienced duplicate sessions in the snowplow_web_base_sessions_lifecycle_manifest table you should perform a full refresh of the package to remove them:

dbt run --models snowplow_web --full-refresh --vars 'snowplow__allow_refresh: true'
2 Likes