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!
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?
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.
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.
@pearsonhenri we’ve now got an atomic event schema here.