Jsonschema -> jsonpaths data not loading in redshift

We are working through an issue that has been really strange with the shredding to the Redshift loading process. It has to be something simple on our end, but we have exhausted all options for debugging so sending it out to the community.

Our original POST data that is hitting the collector has a JSON of:

...
"custom":{
"id":"some-text-here"
}
...

The corresponding jsonschema for this element is:

...
		"custom" : {
			"type" : "object",
			"properties" : {
				"id" : {
				"type" : "string",
				}
      		},
     	 "additionalProperties" : true
    	}
...

and the json paths is:

...
    "$.data.custom.id"
...

when inspecting the shredded (good) event, we see the following in the JSON:

...
"custom[id]":"some-text-here"
...

but it is not successfully loading into Redshift. All other columns from the process are loading without error. No linter issues with the schema files or json paths, rdb_load issues, bad events, redshift load errors, etc. It must be a way in which we are accessing the shredded data in the json paths file. Any thoughts to why this would be the case?

Thank you in advance.

We found the issue. The generator was outputting dot notation, and bracket notation was a better fit for this schema.

Hi,
Thanks for updating your thread with the solution - really helpful.
Cheers,
Eddie