Storage loader error

For engineers
3

Hi @mike

Attaching the JSON Schema & JSON path file :

Also please go through the details for reference :

First time when we ran the storage loader it showed the invalid format for json path file, we checked that json path was indeed invalid then we corrected the file and uploaded and again ran the storage loader. this time we got an error regrading non existent table uri_redirect_1 so we created table and again ran the storage loader.

This time we got the error which I posted in the previous post. Hope this will help you to figure out what could be the problem.

JSON Schema

{
	"$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
	"description": "Schema for communication activity tracking",
	"self": {
		"vendor": "com.shaadi",
		"name": "communication_tracking",
		"format": "jsonschema",
		"version": "1-0-0"
	},

	"type" : "object",
	  "properties" : {
		"sender" : {
			"type" : "string"
		},
		"receiver" : {
			"type" : "string"
		},
		"communication_type" : {
			"type" : "string"
		},
		"category1" : {
			"type" : "string"
		},
		"category2" : {
			"type" : "string"
		},  
		"category3" : {
			"type" : "string"
		},
		"action" : {
			"type" : "string"
		},   
		"hash_id" : {
			"type" : "string"
		},
		"receiver_address" : {
			"type" : "string"
		},
		"extra_info1" : {
			"type" : "string"
		},
		"extra_info2" : {
			"type" : "string"
		}
	},
	"additionalProperties" : false
}

JSON Path

{
    "jsonpaths": [
        "$.schema.vendor",
        "$.schema.name",
        "$.schema.format",
        "$.schema.version",

        "$.hierarchy.rootId",
        "$.hierarchy.rootTstamp",
        "$.hierarchy.refRoot",
        "$.hierarchy.refTree",
        "$.hierarchy.refParent",

	"$.data.sender",
        "$.data.receiver",
        "$.data.communication_type",
        "$.data.category1",
        "$.data.category2",
        "$.data.category3",
        "$.data.action",
        "$.data.hash_id",
        "$.data.receiver_address",
        "$.data.extra_info1",
        "$.data.extra_info2"
    ]
}