KEkeboola
Workspaces

Load data using CLONE

Deprecated, use the /load endpoint with loadType: CLONE.

Load tables from Storage into a Workspace using zero-copy cloning. Supported on Snowflake and BigQuery backends. This load type does not support any filtering, processing parameters, or incremental loading. Linked buckets are not supported on BigQuery.

The cloned table is an exact copy of the source table, including the _timestamp system column (unless dropTimestampColumn is set). The load runs as an asynchronous workspaceLoad job.

post/v2/storage/workspaces/{workspaceId}/load-clone

Request

Path parameters

workspaceIdinteger required

ID of the workspace.

Request body

preserveboolean

Keep existing tables in the workspace, otherwise the workspace is purged before loading.

Example request

{
  "input": [
    {
      "source": "in.c-bucket.mytable",
      "sourceBranchId": 1234,
      "destination": "my-table"
    }
  ]
}

Response

Workspace load job enqueued.

idstring required

Job ID.

statusstring required

Current status of the job.

urlstring required

API detail URL for the job.

tableIdstring nullable required

ID of the table affected by the job.

operationNamestring required

Type of operation performed.

operationParamsobject required

Parameters for the operation.

createdTimestring date-time required

Job creation timestamp.

startTimestring date-time nullable required

Job start timestamp.

endTimestring date-time nullable required

Job end timestamp.

runIdstring nullable required

Run ID for the job.

Example response

{
  "id": "22077337",
  "status": "waiting",
  "url": "https://connection.keboola.com/v2/storage/jobs/22077337",
  "tableId": null,
  "operationName": "workspaceLoad",
  "operationParams": {
    "workspaceId": "78423",
    "preserve": false,
    "input": [
      {
        "source": "in.c-application-testing.cashier-data",
        "destination": "my-table"
      }
    ],
    "queue": "main_fast"
  },
  "createdTime": "2017-02-13T16:41:18+0100",
  "startTime": null,
  "endTime": null,
  "runId": null,
  "results": null,
  "creatorToken": {
    "id": "27978",
    "description": "john.doe@keboola.com"
  },
  "actor": {
    "type": "token",
    "id": "27978",
    "name": "john.doe@keboola.com",
    "adminId": 1234
  },
  "metrics": {
    "inCompressed": false,
    "inBytes": 0,
    "inBytesUncompressed": 0,
    "outCompressed": false,
    "outBytes": 0,
    "outBytesUncompressed": 0
  }
}

Changes

No recorded changes to this operation across all 1 revision of this API.