← The ShowroomData & analysis

Writeup only

dbt-adobe-events

A planned open-source package that turns raw Adobe event data into clean, tested analytics tables.

Status
Spec only
Built with
Planned: dbt SQL models
Last worked on
2026-08

What it is

dbt-adobe-events is a plan for a free, open-source building block for data teams. dbt is a popular tool for turning raw warehouse data into tidy tables using version-controlled SQL. Adobe's event data arrives in warehouses in awkward shapes: deeply nested JSON, mirror tables, or files with about a thousand columns. This package would read any of those and produce a standard set of clean, documented, tested tables, so each team stops writing the same cleanup by hand.

How it works

As planned:

  1. Install the package into an existing dbt project.
  2. Set a few variables to say where the raw data lives and which format it is in.
  3. Run dbt build.
  4. The package flattens and types the raw events, removes duplicates, groups hits into sessions, labels event types and assigns marketing channels with a rules engine.
  5. Out come ready tables: events, page views, sessions, users, conversions, order items, and a daily table for comparing two Adobe products' numbers.

What exists today

What isn't there yet

Under the hood