Keboola · Schema

CreateTableAsyncFromFileRequest

Request body for creating a table from a file. Some parameters are optional or only used for specific backends.

Data PlatformETLELTData PipelinesData StorageTransformationsOrchestrationData OperationsCloud DataSnowflakeBigQuery

Properties

Name	Type	Description
dataFileId	integer	ID of the source data file.
name	string	Name of the new table.
delimiter	string	CSV delimiter character.
enclosure	string	CSV enclosure character.
escapedBy	string	CSV escape character.
primaryKey	array	Primary key columns.
columns	array	List of table columns (optional, only for file workspace).
distributionKey	array	Distribution key columns (for Synapse).
timestampType	string	Type of internal timestamp column only MANAGED value now supported, meaning that _timestamp column managed by storage is created.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "title": "CreateTableAsyncFromFileRequest",
  "description": "Request body for creating a table from a file. Some parameters are optional or only used for specific backends.",
  "required": [
    "dataFileId",
    "name",
    "primaryKey",
    "distributionKey"
  ],
  "properties": {
    "dataFileId": {
      "description": "ID of the source data file.",
      "type": "integer"
    },
    "name": {
      "description": "Name of the new table.",
      "type": "string"
    },
    "delimiter": {
      "description": "CSV delimiter character.",
      "type": "string",
      "nullable": true
    },
    "enclosure": {
      "description": "CSV enclosure character.",
      "type": "string",
      "nullable": true
    },
    "escapedBy": {
      "description": "CSV escape character.",
      "type": "string",
      "nullable": true
    },
    "primaryKey": {
      "description": "Primary key columns.",
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "columns": {
      "description": "List of table columns (optional, only for file workspace).",
      "type": "array",
      "items": {
        "type": "string"
      },
      "nullable": true
    },
    "distributionKey": {
      "description": "Distribution key columns (for Synapse).",
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "timestampType": {
      "description": "Type of internal timestamp column only MANAGED value now supported, meaning that _timestamp column managed by storage is created.",
      "type": "string",
      "nullable": true,
      "default": "MANAGED"
    }
  },
  "type": "object"
}