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?
Colm
January 24, 2019, 6:03pm
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.
anton
January 25, 2019, 11:52am
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.
Colm
March 1, 2019, 6:10pm
5
@pearsonhenri we’ve now got an atomic event schema here .
2 Likes
