Keboola · Schema

TableCreateResponse

Data PlatformETLELTData PipelinesData StorageTransformationsOrchestrationData OperationsCloud DataSnowflakeBigQuery

Properties

Name	Type	Description
uri	string	Table API URI
id	string	Table ID
name	string	Table name
displayName	string	Table display name
transactional	boolean	Is transactional
primaryKey	array	Primary key columns
indexType	string	Index type
indexKey	array	Index key columns
distributionType	string	Distribution type
distributionKey	array	Distribution key columns
syntheticPrimaryKeyEnabled	boolean	Synthetic primary key enabled
created	string	Created timestamp
lastImportDate	string	Last import date
lastChangeDate	string	Last change date
rowsCount	integer	Rows count
dataSizeBytes	integer	Data size in bytes
isAlias	boolean	Is alias
isAliasable	boolean	Is aliasable
isTyped	boolean	Is typed table
tableType	string	Table type
path	string	Table path
columns	array	List of column names
sourceTable	object	Source table info (for aliases)
aliasColumnsAutoSync	boolean	Alias columns auto sync (for simple aliases)
aliasFilter	object	Alias filter (for filtered aliases)
selectSql	string	Custom SQL for alias (for custom SQL aliases)

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "title": "TableCreateResponse",
  "required": [
    "uri",
    "id",
    "name",
    "displayName",
    "transactional",
    "primaryKey",
    "indexType",
    "indexKey",
    "distributionType",
    "distributionKey",
    "syntheticPrimaryKeyEnabled",
    "created",
    "lastImportDate",
    "lastChangeDate",
    "rowsCount",
    "dataSizeBytes",
    "isAlias",
    "isAliasable",
    "isTyped",
    "tableType",
    "path",
    "columns"
  ],
  "properties": {
    "uri": {
      "description": "Table API URI",
      "type": "string"
    },
    "id": {
      "description": "Table ID",
      "type": "string"
    },
    "name": {
      "description": "Table name",
      "type": "string"
    },
    "displayName": {
      "description": "Table display name",
      "type": "string"
    },
    "transactional": {
      "description": "Is transactional",
      "type": "boolean"
    },
    "primaryKey": {
      "description": "Primary key columns",
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "indexType": {
      "description": "Index type",
      "type": "string",
      "nullable": true
    },
    "indexKey": {
      "description": "Index key columns",
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "distributionType": {
      "description": "Distribution type",
      "type": "string",
      "nullable": true
    },
    "distributionKey": {
      "description": "Distribution key columns",
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "syntheticPrimaryKeyEnabled": {
      "description": "Synthetic primary key enabled",
      "type": "boolean"
    },
    "created": {
      "description": "Created timestamp",
      "type": "string",
      "format": "date-time",
      "nullable": true
    },
    "lastImportDate": {
      "description": "Last import date",
      "type": "string",
      "format": "date-time",
      "nullable": true
    },
    "lastChangeDate": {
      "description": "Last change date",
      "type": "string",
      "format": "date-time",
      "nullable": true
    },
    "rowsCount": {
      "description": "Rows count",
      "type": "integer",
      "nullable": true
    },
    "dataSizeBytes": {
      "description": "Data size in bytes",
      "type": "integer",
      "nullable": true
    },
    "isAlias": {
      "description": "Is alias",
      "type": "boolean"
    },
    "isAliasable": {
      "description": "Is aliasable",
      "type": "boolean"
    },
    "isTyped": {
      "description": "Is typed table",
      "type": "boolean"
    },
    "tableType": {
      "description": "Table type",
      "type": "string"
    },
    "path": {
      "description": "Table path",
      "type": "string"
    },
    "columns": {
      "description": "List of column names",
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "sourceTable": {
      "oneOf": [
        {
          "$ref": "#/components/schemas/SourceTableResponse"
        }
      ],
      "nullable": true,
      "description": "Source table info (for aliases)"
    },
    "aliasColumnsAutoSync": {
      "description": "Alias columns auto sync (for simple aliases)",
      "type": "boolean",
      "nullable": true
    },
    "aliasFilter": {
      "description": "Alias filter (for filtered aliases)",
      "type": "object",
      "nullable": true
    },
    "selectSql": {
      "description": "Custom SQL for alias (for custom SQL aliases)",
      "type": "string",
      "nullable": true
    }
  },
  "type": "object"
}