Last Updated:

Data Schema

Data Schema Format

Data schema is written in JSON-format. You cannot change the order of elements.

Example:

{
  "SchemaVersion": "1.0",
  "TableDefinition": {
    "Columns": [
      { "Name": "col1", "DataType": { "DataType": "number" } }
    ]
  },
  "DataSpecification": {
    "FormatType": "csv",
    "DeliveryType": "file",
    "DataOptions": {
      "Header": true,
      "Encoding":"utf-8",
      "FieldDelimiter":",",
      "NullString":"NA"
    }
  }
}

SchemaVersion

Specifies the version of schema.

Only "1.0" is supported.

TableDefinition

Specifies the table structure.

Columns

List of columns of the table.

  • Name: the column name (must starts with alphabet and contains only alphabet, numeric, or underscore)
  • DataType: the data type

DataSpecification

Specifies the input data.

FormatType

Specifies the file format.

Only "CSV" is supported.

DeliveryType

Specifies the file delivery.

Only "file" is supported.

DataOptions

Specifies the options for the file reader.