We are very happy to announce the release of a new dbt package, Snowplow Normalize v0.1.0! This package enabled users to easily convert their atomic events table into one table per event type for use in downstream reverse ETL tools, all by using the schemas you use to track your events meaning you don’t have to type all the event/context atributes yourself!
The package currently only supports BigQuery, Snowflake, and Databricks.
You can find the docs for the package here: The Normalize data model | Snowplow Documentation
And a quickstart video here: Snowplow Normalize dbt package Quickstart - YouTube
If you have any feedback or requests please let us know either via discourse or on the github repo. We’re currently planning a few things for version 0.2.0 already including multiple event types per table, choice of
user_id field, and support for multiple versions of columns from BigQuery, so keep your eyes out for them!