Keboola · Schema

CreateTableAsyncFromTimeTravelRequest

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

Data PlatformETLELTData PipelinesData StorageTransformationsOrchestrationData OperationsCloud DataSnowflakeBigQuery

Properties

Name	Type	Description
sourceTableId	string	ID of the source table for time travel.
name	string	Name of the new table.
timestamp	string	Timestamp for time travel (ISO8601 or unix timestamp).
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": "CreateTableAsyncFromTimeTravelRequest",
  "description": "Request body for creating a table from a time travel source. Some parameters are optional or only used for specific backends.",
  "required": [
    "sourceTableId",
    "name",
    "timestamp",
    "primaryKey",
    "distributionKey"
  ],
  "properties": {
    "sourceTableId": {
      "description": "ID of the source table for time travel.",
      "type": "string"
    },
    "name": {
      "description": "Name of the new table.",
      "type": "string"
    },
    "timestamp": {
      "description": "Timestamp for time travel (ISO8601 or unix timestamp).",
      "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"
}