Unable to get geo details using snowplow mini(AWS)

Hi Can someone guide me here to get geo details
Unable to get geo details using snowplow mini(AWS) through Android SDK using self-describing JSON. I could see event data in Kibana. But I am unable to get Geo details like City, Zipcode etc.,

Steps followed:

  1. downloaded MaxMind DB. GeoLite2-City.mmdb and GeoLite2-ASN.mmdb and updated to S3 to bucket name “mybucket”
  2. here is the schema

{
“$schema”: “http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/test/jsonschema/1-0-0#”,
“description”: “test”,
“self”: {
“vendor”: “com.test”,
“name”: “test”,
“format”: “jsonschema”,
“version”: “1-0-0”
},
“type”: “object”,
“properties”: {
“category”: {
“type”: “string”,
“maxLength”: 100,
“description”: “event category”
},
“action”: {
“type”: “string”,
“maxLength”: 100,
“description”: “the action that was performeda by the actor”
},
“label”: {
“type”: “string”,
“maxLength”: 255,
“description”: “a string to provide additional dimensions to the event data”
},
“workspaceId”: {
“type”: “string”,
“description”: “workspace id”
},
“session”: {
“type”: “string”,
“maxLength”: 36,
“description”: “IDE session uuid”
},
“geo”: {
“database”: “GeoLite2-City.mmdb”,
“uri”: “s3://mybucket”
}
} ,
“required”: [
“category”,
“action”,
“session”,
“workspaceId”
],
“additionalProperties”: true
}

@Llazarusjohn, you need to have IP lookups enrichment enabled on your pipeline. It’s not going to work by embedding the database into the events themselves.

does Snowplow-Mini allow enrichment?

Yes - Snowplow mini allows enrichments through uploading via the control plane.

Thank you will try

For me this didn’t work, see Ip_lookup enrichment in Snowlplow mini

IP Enrichment in Snowplow Mini was disabled in version 0.7.0 due to the MaxMind access policy change.

We’re working on a new mechanism to get this working again in a future release (likely 0.9.0).

1 Like