Snowplow dbt package releases (Unified, Utils and more)

We are excited to announce the release of several dbt packages:

dbt-snowplow-unified v0.2.0

This release adds the ability to calculate mobile screen engagement using the screen summary context. There is also a new optional module for a conversions table. Other changes are the ability to stitch the users table during session stitching and heatset is a recognised platform now.

:rotating_light: Breaking Changes :rotating_light:

Existing users on Snowflake / Databricks / Redshift will need to make changes to their derived views table. For a full sql script on how to achieve this, check out the relevant migration guide. The other option is to do a complete refresh of the package.

Features

  • Add mobile screen engagement calculation using the screen summary context (#16)
  • Adds user stitching to the users table (enabled with snowplow__session_stitching)
  • Adds β€œheadset” to the list of recognized platforms
  • Add optional conversions module

Fixes

  • Consider screen view ID from the screen view context (#14)
  • Fix link to incorrect FAQ in README
  • Remove test for not null screen ID and name in app errors table

Upgrading

Bump the snowplow-unified version in your packages.yml file and follow all the other steps in our migration guide.

dbt-snowplow-utils v.0.16.0 / 0.16.1

This release contains a new array size macro as well as the optional ability for the unnest macros to also surface the index of the original array element for preserving the order. It also contains some fixes for redshift. Please note that from this version onwards this package is under the SPAL license. v0.16.1 fixes a bug for Redshift.

Features

  • Add get_array_size macro
  • Add optional index to unnest

Fixes

  • Fix existing tests for redshift
  • Fix issue with multiple end hooks failing (Close #152)

Under the hood

  • Update license to SPAL

Upgrading

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

dbt-snowplow-media-player v.0.17.1

This version bumps the package dependency to add support for the latest snowplow utils package.

Upgrading

To upgrade simply bump the snowplow-media-player version in your packages.yml file.

dbt-snowplow-ecommerce v.0.17.1

This version bumps the package dependency to add support for the latest snowplow utils package.

Upgrading

To upgrade simply bump the snowplow-ecommerce version in your packages.yml file.

dbt-snowplow-normalize v.0.3.4

This version bumps the package dependency to add support for the latest snowplow utils package. Please note that from this version onwards this package is under the SPAL license.

Upgrading

To upgrade simply bump the snowplow-normalize version in your packages.yml file.

4 Likes