Skip to content

New JSON Path file, SQL table definition and migration script for com.snowplowanlaytics.snowplow geolocation_context 1-1-0 #519

Description

*Migrated from: * snowplow/snowplow#2864

I noticed the new 1-1-0 schema includes the timestamp from the geo location API. However we don't have a migration script, table def or JSON path file to make use of it in Redshift. Currently just:

JSON Schema
https://github.com/snowplow/iglu-central/blob/master/schemas/com.snowplowanalytics.snowplow/geolocation_context/jsonschema/1-1-0

JSON path
https://github.com/snowplow/snowplow/blob/master/4-storage/redshift-storage/jsonpaths/com.snowplowanalytics.snowplow/geolocation_context_1.json

Table definition
https://github.com/snowplow/snowplow/blob/master/4-storage/redshift-storage/sql/com.snowplowanalytics.snowplow/geolocation_context_1.sql

Would you guys be open to a pull request for 1-1-0 files? We've started collecting fine locations as part of a split test and will be writing these ourselves anyway.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions