JSON Definition Language

treysmithdev — Tue, 07 Dec 2021 22:35:04 GMT

Does anyone know where the full JSON Definition Language (JDL) spec is? I'm trying to load some JSON files I have converted and it seems I need to generate a definition file as well, but I have not been able to find any documentation outside of the training slide.

Re: JSON Definition Language

treysmithdev — Wed, 02 Oct 2019 15:43:09 GMT

I was able to find the documentation in the embedded QDC documentation: Source > JSON > JSON Overview.

Here is the specific documentation I was looking for:

datasetName:	String name of the datasets. Should not contain whitespace. May contain underscore characters.
jsonRecordStructure:	JSON_OBJECT
jsonDatasetOrganization:	Should contain one of: SINGLETON_JSON_VALUE SEQUENCE_OF_JSON_VALUES
table:	Defines the name of a table to be extracted as well as the JSON-path for JSON values to be used for the table. This directive may occur more than once in a single .hen file to define multiple tables for a single JSON dataset.

Example:

{ "datasetName": "tickets", "jsonRecordStructure": "JSON_OBJECT", "jsonDatasetOrganization": "SINGLETON_JSON_VALUE", "tableDefinitions": [ { "tableName": "store", "tableDriverSpecification": "$.store[*]", "fieldDefinitions": [ {"fieldName": "ticketId", "fieldSpecificationString": "$.store[*].id" }, {"fieldName": "created_at", "fieldSpecificationString": "$.store[*].created_at" }, {"fieldName": "raw_subject", "fieldSpecificationString": "$.store[*].raw_subject" }, {"fieldName": "tags", "fieldSpecificationString": "$.store[*].tags" }, {"fieldName": "tags2", "fieldSpecificationString": "$.store[*].tags[*]" }, {"fieldName":"firstCustomFieldValue","fieldSpecificationString":"$.store[*].customFields[0].value" }, {"fieldName": "ticketJson", "fieldSpecificationString": "$.store[*]" } ] }, { "tableName": "store_tag", "tableDriverSpecification": "$.store[*].tags[*]", "fieldDefinitions": [ {"fieldName": "ticketId", "fieldSpecificationString": "$.store[*].id" }, {"fieldName": "tag", "fieldSpecificationString": "$.store[*].tags[*]" } ] } ] }

Source:

topic Re: JSON Definition Language in Catalog and Lineage

JSON Definition Language

Re: JSON Definition Language