snowplow-ecommerce v0.9.0

Summary

This release introduces support for Apache Spark with the Iceberg file format and updates integration tests to ensure compatibility.

Features

• Add support for Apache Spark with Iceberg file format

Under the hood

• Modify integration tests to support Spark

Upgrading

Update the snowplow-ecommerce version in your packages.yml file.

snowplow-ecommerce v0.8.2

Summary

This release fixes a bug on Redshift that caused an error in case transactions were disabled.

Fixes

• Fix error on Redshift due to base_events_this_run using the transaction_id as partition key event if transactions are disabled (#51)

Upgrading

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

snowplow-ecommerce v0.8.1

Summary

This release makes a few internal tweaks, including adding support for schema grants, and adding support for a custom database on redshift in product interactions this run

Features

• Add support for schema grants
• Add support for custom database in get_sde_or_context call

Under the hood

• Migrate delete from manifest to our utils package
• Enforce full refresh flag and snowplow__allow_refresh for full refresh on manifest tables
• Bump minimum snowplow-utils version to 0.16.3

Upgrading

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

snowplow-ecommerce v0.8.0

Summary

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.

🚨 Breaking Changes 🚨

• 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.

Fixes

• 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

Upgrading

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.

snowplow-ecommerce 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-ecommerce version in your packages.yml file.

snowplow-ecommerce v0.7.0

Summary

This release provides a solution for when multiple events are sent for a single transaction.

From this release onwards, the package is being released under the Snowplow Personal and Academic License . If you are uncertain how it applies to your use case, check our answers to frequently asked questions.

Breaking Changes

• This package is now under the SPAL License

Fixes

• In the case of multiple transaction events being sent these are now deduplicated to take the first for that transaction_id within a session.

Upgrading

To upgrade bump the snowplow-ecommerce version in your packages.yml file. If you have run the package with multiple events for a single transaction, you made need to do a full refresh.

snowplow-ecommerce v0.6.1

Summary

This release fixes an issue with snowflake schema attribute names in our macros.

Fixes

• Fix incorrect schema attribute names in our macros

Upgrading

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

snowplow-ecommerce v0.6.0

Summary

This release adds the base macro approach to the core models of the package. 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. This release also contains other small enhancements and fixes to various tables. Note a full-refresh is not required unless you plan to change your identifiers, but you do need to run the statements in the migration guide.

Breaking Changes

• This package now requires at least version 0.15.0 of snowplow_utils
• We now require at least version 1.5.0 of dbt
• Renamed columns in quarantined sessions and sessions lifecycle manifest table (please run the ALTER TABLE statements in the migration guide or do a full-refresh)

Features

• Migrate base models to the new base macros for flexibility and consistency
• Add ability to add custom entity/self-describing event columns to the base_events_this_run table for Redshift/Postgres
• Add ability to use a custom session identifier and user identifier
• Add ability to pass fields through to derived page views, sessions, and user tables
• Add ecommerce_action_type and ecommerce_action_name to product_intercations
• Add app_id field to derived models

Under the hood

• Aligned variables to follow the public docs

Upgrading

To upgrade bump the snowplow-ecommerce version in your packages.yml file and follow the migration guide.

snowplow-ecommerce v0.5.4

Summary

This release fixes an issue for users using a utils version 0.15.1 or greater.

Fixes

Fix error with new utils version on end hook.

Upgrading

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

snowplow-ecommerce v0.5.3

Summary

Bumps the max supported snowplow-utils version to allow usage with our other packages.

Upgrading

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