Snowplow ecommerce 0.8.0

We are happy to announce the release of snowplow-ecommerce v0.8.0. This release makes some changes to the logic of the sessions table to ensure we only include sessions that have valid ecom events. This release will be on the dbt hub within the next few hours.


This release makes a few core changes to the sessions table. It stops non-ecommerce sessions being added to the derived table, and provides sensible defaults for numeric and boolean columns.

:rotating_light: Breaking Changes :rotating_light:

  • The sessions table now has sensible defaults (0 or false) for most numeric or boolean fields, even when that session did not have e.g. any cart events. Previously these were null.


  • Fix issue where non-ecommerce sessions were showing in the sessions table. Note a full refresh is required to remove old sessions of this type.

  • Fix an incorrect variable name in our package defaults

Under the hood

  • Simplified integration tests


To upgrade simply bump the snowplow-ecommerce version in your packages.yml file. If you want to remove old sessions that shouldn’t have been included, or populate nulls in the sessions table column, please do a full refresh.

1 Like