We are happy to announce the release of the snowplow-media_player 0.7.0 dbt package!
This version adds new features powered by a complete refactor of the core processing of the package by moving it out to the new
base macro functionality provided in
snowplow_utils. This enables users to now specify custom fields for sessionization and user identification, to add custom entities/SDEs fields to the base events table for redshift/postgres, and to add passthrough fields to the derived tables so you can now more easily add your own fields to our tables.
The default session identifier has been updated from using the domain_sessionid, to now be the media session id (or the page/screen view id if the media session entity is not set). Previously media events from a play that overlapped to a new domain_sessionid were discarded, this update ensures the complete media play is modeled. It is still possible to perform the original session level analysis using the new
In addition this release adds a more robust unique media identifier. This fixes an issue where duplicate
media_id values could occur in the media stats table as a result of incorrect tracking implementation (e.g. sharing the same media label across different media types). This release also fixes the incremental materialization of the media_ad_views table by adding a unique primary key.
Migrate base models to the new
basemacros for flexibility and consistency
Updated the default session identifier to be the media session id (or page/screen view id if the media session entity is not set)
Add ability to pass fields through to derived media base and ad views tables
Add new field
domain_sessionid_arrayto derived tables (where applicable)
Add unique media identifier
Add missing primary key to media_ad_views
Fix field names in custom session stats model yaml
Fix playback_quality_field macro
This version requires a full refresh run if you have been using any previous versions. You will not be able to upgrade and have the package work without doing a full refresh. Check out the migration guide for more information when you upgrade.
This release will be available on dbt hub in the next couple of hours. To upgrade simply bump the snowplow-media-player version in your