KEkeboola
Buckets

Bucket Tables Information Refresh

Refresh tables information in bucket. Available for Snowflake and BigQuery backends, not for external buckets. The refresh runs in a background job; to see the job detail use the Job Detail endpoint.

On Snowflake it refreshes the row count and data size of the bucket's tables. Aliases with source table in the defined bucket are also refreshed. If an alias in the discussed bucket has its source table in another bucket, it won't be refreshed.

On BigQuery it re-reads the policy tags of the bucket's dataset and records them, so a tag set or removed directly in BigQuery shows in the table detail's policyTagState. Column definitions, row count and data size are not changed, and aliases are not refreshed. It runs one BigQuery INFORMATION_SCHEMA query per refresh, which BigQuery bills.

post/v2/storage/branch/{branchId}/buckets/{bucketId}/refresh-tables-info

Request

Path parameters

bucketIdstring required

Bucket ID.

branchIdstring required

Response

Refresh job enqueued; returns job details.

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.