Skip to main content

Mojito Snowplow Storage overview

This component allows you to collect experiment events and perform the necessary data modelling for Mojito R Analytics reports and other tools.

There are two parts to this component:

  1. Events (./events): Self-describing events emitted from experiments, comprised of JSON schemas and Snowplow JSON Paths / Redshift tables
  2. Data models ./redshift-datamodels: SQL data models for attributing conversions back to variant exposures in reporting


To make use of this out of the box, you'll need:

  • Snowplow running with Redshift as a storage target
  • Snowplow's SQL Runner app

It's possible to do this without the above, but you'll need some heavy modification.

Getting started

Add the events to your Iglu and setup your data modelling steps in SQL Runner:

  1. Add JSON schema to your Iglu
    • This is required for event validation and shredding during enrichment
  2. (Redshift only) Put the JSON paths files in your JSON paths folder
    • If running Redshift, this maps the JSON keys to your table fields
  3. (Redshift only) Create the tables in Redshift for loading shredded events
    • If running Redshift, this is the table definition that shredded events will populate
  4. Setup SQL Runner to load your report tables each day (Redshift data models)
    • This step creates the data model used for reporting

Future work

We intend to support GCP/BigQuery in the future as we need, but for now, we only support Redshift.

Get involved

Let us know if you encounter any issues and reach out to us if you need a hand getting set up.