Store deviceFamily data into events table


#1

Hi,

After enrichment the following data is available for storage-loader, I need to store the deviceFamily data into the atomic.events table. How can I store additional information from enrichment process into storage ?

storage: PostgreSql

{“schema”:“iglu:com.snowplowanalytics.snowplow/contexts/jsonschema/1-0-1”,“data”:[{“schema”:“iglu:com.snowplowanalytics.snowplow/ua_parser_context/jsonschema/1-0-0”,“data”:{“useragentFamily”:“Chrome Mobile”,“useragentMajor”:“57”,“useragentMinor”:“0”,“useragentPatch”:“2987”,“useragentVersion”:“Chrome Mobile 57.0.2987”,“osFamily”:“Android”,“osMajor”:“6”,“osMinor”:“0”,“osPatch”:“1”,“osPatchMinor”:null,“osVersion”:“Android 6.0.1”,“deviceFamily”:“Nexus 5”}}]}


#4

Hi @v3nom,

Currently, the shredded data cannot be loaded into Postgres. The reason for that is the shredded data (that is those that require a dedicated table rather than events table) are in JSON format. When it comes to Redshift, the data can be easily loaded with the native COPY FROM JSON command.

Postgres has a JSON datatype, although the querying capabilities on that JSON datatype are so-far primitive. We plan on supporting full shredding into Postgres tables, the same as we do with Redshift, in the future - but that is still some way off.