ELI5: Where can I find the schema for the canonical event model?

#1

Maybe I’m doing something wrong here, but basically I’m looking for a schema akin to this guy https://github.com/snowplow/iglu-central/blob/a65bd9574c3bb34f1699afda5a22c3e717df3f78/schemas/com.snowplowanalytics.snowplow/elasticsearch_enriched_event/jsonschema/2-0-0, but just the standard event format. The use case here is that I’m trying to deviate slightly from the ordained Snowplow path by pushing my enriched events into a Kinesis Firehose, then writing them to a Redshift table. Obviously the table structure I’m writing to will just be based on the canonical event JSON schema, but I can’t actually find that anywhere to incorporate it.

Am I “doing it wrong?” Any pointers would be gratefully appreciated! :slight_smile:

0 Likes

#2

Ah, of course–as soon as I asked this question, I managed to find this: https://github.com/snowplow/snowplow/blob/master/4-storage/redshift-storage/sql/atomic-def.sql

This is enough for me to get the job done hackily. Anybody going any pointers for how I can find this schema in Iglu?

0 Likes

#3

I don’t think there’s a JSONschema for it. There’s a schema for each event, and there’s the tracker protocol, as well as that table def., but AFAIK it doesn’t exist anywhere in JSON form.

0 Likes

#4

Hi @pearsonhenri,

Yeah, we have this in plans https://github.com/snowplow/iglu-central/issues/778, but no ETA yet. It would greatly simplify a workflow of any app downstream enrich.

0 Likes

#5

@pearsonhenri we’ve now got an atomic event schema here. :slight_smile:

1 Like

#6

Yay!! Thanks guys :slight_smile:

0 Likes