snowplow-media-player v0.9.1

Summary

This patch release adds app_id as a new field in some of the derived tables and includes a bug fix related to user identification handling in ad_views.

Features

• Introduced app_id field across some of the derived tables to improve application-level analytics

Fix

• Optimized user_id aggregation, changed from GROUP BY to MAX(user_id) in queries in ad_view, because it could cause duplicates in an edge case.

Upgrading

To upgrade, update the snowplow-media-player version in your packages.yml file. Please note:

• The new app_id field will be populated for new data points automatically
• Although this is a non-breaking change, historical data will require a full refresh to include app_id values, if needed

snowplow-media-player v0.9.0

Summary

This release adds support for Apache Spark with the Iceberg file format and updates integration tests to ensure proper functionality.

Features

• Add support for Apache Spark with Iceberg file format

Under the hood

• Modify integration tests to support Spark

Upgrading

Update the snowplow-media-player version in your packages.yml file.

snowplow-media-player v0.8.0

Summary

This release adds support for video playback across multiple pages/screens (e.g., while in picture-in-picture mode).
It also fixes the calculation of impressions in the stats table to use distinct plays instead of page views. This allows for multiple videos on the same page.

Features

• Add support for picture-in-picture playback of videos across multiple pages/screens (#70)

Fix

• Fix counting impressions based using distinct play_id instead of page_view_id (#72)

Under the hood

• Run tests on Redshift in CI (#74)

🚨 Breaking Changes 🚨

This version requires a full refresh run if you have been using any previous versions. Otherwise the calculation of the impressions and play_rate columns in the media stats table will be inconsistent with historical data. Check out the migration guide for more information when you upgrade.

snowplow-media-player v0.7.2

Summary

This release makes a few internal tweaks, including adding support for schema grants

Features

• Add support for schema grants

Fix

• Add missing argument in delete from manifest call

Under the hood

• Enforce full refresh flag to refresh manifest tables

Upgrading

To upgrade simply bump the snowplow-media-player version in your packages.yml file. Note the minimum version of snowplow-utils required is now 0.16.2

snowplow-media-player v0.7.1

Summary

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

Under the hood

• Bump support for latest utils

Upgrading

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

snowplow-media-player v0.7.0

Summary

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 domain_sessionid_array field.

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.

Features

• Migrate base models to the new base macros for flexibility and consistency
• Updated the default session identifier 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_array to derived tables (where applicable)

Fixes

• Add unique media identifier (close #59)
• Add missing primary key to media_ad_views
• Fix field names in custom session stats model yaml (close #63)
• Fix playback_quality_field macro (close #60)

🚨 Breaking Changes 🚨

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.

snowplow-media-player v0.6.1

Summary

This release fixes an issue for users using a utils version 0.15.1 or greater, and fixes an issue with disabling the new contexts on databricks and redshift.

Fixes

• Fix error with new utils version on end hook
• Fix issue with disabling new contexts on redshift and databricks

Upgrading

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

snowplow-media-player v0.6.0

Summary

This release brings support for new media event and context entity schemas tracked using the JavaScript as well as mobile (iOS and Android) trackers. It also adds new features on top of the new media schemas such as ad tracking models and more accurate playback metrics.

Features

Add support for new Snowplow media event and entity schemas on Web and mobile (close #49)
Replace snowplow_web with a base that can be compatible with mobile events (close #45)

Under the hood

Update license to SPAL
Bump support for utils versions

🚨 Breaking Changes 🚨

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.

snowplow-media-player v0.5.3

Summary

This release fixes a problem reported with the media_stats model failing during incremental runs when the table is empty.

Fixes

Fix errors during media_stats incremental runs in case the table is empty (close #51)

Upgrading

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

snowplow-media-player v0.5.2

Summary

This release fixes an issue on Redshift due to default function names.

Fixes

Fix current_time issue (Close #46)

Upgrading

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