snowplow-unified v0.2.0

Summary

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.

🚨 Breaking Changes 🚨

Existing users on Snowflake / Databricks / Redshift will need to make changes to some of their derived tables. 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.

snowplow-unified v0.1.2

Summary

This is a patch release to fix the default browser context variable for warehouses other than redshift/postgres.

Fixes

• Fix browser context

Upgrading

Bump the snowplow-unified version in your packages.yml file.

snowplow-unified v0.1.1

Summary

This release is for supporting multiple versions of the session context schema for Bigquery (mobile) users not just contexts_com_snowplowanalytics_snowplow_client_session_1_0_0 out-of-the-box.

Features

• Support latest session context schema

Github

packages:
  - git: "https://github.com/snowplow/dbt-snowplow-unified.git"
    revision: 0.1.1

dbt hub

packages:
  - package: snowplow/snowplow_unified
    version: [">=0.1.0", "<0.2.0"]

snowplow-unified v0.1.0

Summary

This is the first official release of the Snowplow Unified package, which contains a fully incremental model that transforms raw web and mobile event data generated by the Snowplow JavaScript and mobile trackers into a set of derived tables: views, sessions and users.

Features

• dbt Package that processes web and mobile events simultaneously
• Support for Snowflake / BigQuery / Databricks / Redshift / Postgres
• optional modules such as consent, app errors and web performance (core web vitals)

Please note that this data model is under the Snowplow Personal & Academic License (SPAL). For further details please refer to our documenation site.

Installation

To install the package, add the following to the packages.yml in your project:

Github

packages:
  - git: "https://github.com/snowplow/dbt-snowplow-unified.git"
    revision: 0.1.0

dbt hub

Please note that it may be a few days before the package is available on dbt hub after the initial release.

packages:
  - package: snowplow/snowplow_unified
    version: [">=0.1.0", "<0.2.0"]

snowplow-unified v0.0.1

snowplow-unified 0.0.1 (2023-10-24)

Summary

This is the first release of the Snowplow Unified package, which contains a fully incremental model that transforms raw web and mobile event data generated by the Snowplow JavaScript and mobile trackers into a set of derived tables: views, sessions and users.

Features

• dbt Package that processes web and mobile events simultaneously
• Support for Snowflake / BigQuery / Databricks / Redshift / Postgres
• optional modules such as consent, app errors and web performance (core web vitals)

Installation

To install the package, add the following to the packages.yml in your project:

Github

packages:
  - git: "https://github.com/snowplow/dbt-snowplow-unified.git"
    revision: 0.0.1