Passing values from atomic.events to a custom table

For data modelers & consumers Redshift
6

Hi @cdimitroulas,

You can find examples in Iglu Central: GitHub - snowplow/iglu-central: Contains all JSON Schemas, Avros and Thrifts for Iglu Central

Iglu Central (website) is a central repository for storing JSON Schemas, Avros and Thrifts, maintained and hosted by the team at Snowplow Analytics. Think of it like RubyGems.org or Maven Central but for storing data schemas instead of code.

For example: this is the JSON schema for a generic ad impression events we defined: ad_impression.

Two more files are created from the JSON schema:

You can use igluctl to auto-generate them from the schema. The table names follows straight from the schema:

  • schema vendor
  • schema name
  • schema version

If you want to learn more about the role of JSONPaths, I recommend reading this excellent post by @ihor on the role they play in the loading process: JSONPaths files demystified

Hope this helps!