Amazon Redshift · JSON Structure

Amazon Redshift Data Column Metadata Structure

Type: object Properties: 13
AnalyticsBig DataCloudData LakeData WarehouseETLMachine LearningServerlessSQL

ColumnMetadata is a JSON Structure definition published by Amazon Redshift, describing 13 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

name label typeName columnDefault isCaseSensitive isCurrency isSigned nullable precision scale length schemaName tableName

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "ColumnMetadata",
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "label": {
      "type": "string"
    },
    "typeName": {
      "type": "string"
    },
    "columnDefault": {
      "type": "string"
    },
    "isCaseSensitive": {
      "type": "boolean"
    },
    "isCurrency": {
      "type": "boolean"
    },
    "isSigned": {
      "type": "boolean"
    },
    "nullable": {
      "type": "integer"
    },
    "precision": {
      "type": "integer"
    },
    "scale": {
      "type": "integer"
    },
    "length": {
      "type": "integer"
    },
    "schemaName": {
      "type": "string"
    },
    "tableName": {
      "type": "string"
    }
  }
}