json2table-schema

CLI tool to generate a table-schema provided a path to some sample JSON.

The sample JSON should be an array of objects.

It will loop thru each object, flatten them down into a tabular format, and produce a schema compliant with this spec: https://frictionlessdata.io/docs/table-schema/

The "name" property will be alphanumeric with underscores -- this is compatible with Google BigQuery's tables, as well as likely every database under the sun.

In addition to the "name" field, it will also add a "jsonPath" property to each field.

This jsonPath is compliant with lodash/get for getting data from json blobs of the same shape.

It does NOT automatically fill in the "type" and "description" fields, but it does produce them as empty placeholders.

Installation

npm i -g json2table-schema

Usage

json2table-schema /path/to/example.json

Example

$ json2table-schema ./example/eg6.json | jq
{
  "fields": [
    {
      "name": "col1",
      "type": "string",
      "description": "",
      "jsonPath": "col1"
    },
...