KEkeboola
Buckets

Bucket Detail

Obtains information about a bucket, including its metadata, tables, scheduled tasks, listing and buckets linked to it.

get/v2/storage/buckets/{bucketId}

Request

Path parameters

bucketIdstring required

Bucket ID.

Query parameters

includestring

Comma-separated list of resources to include for each table: metadata (table metadata), columns (table columns), columnMetadata (column metadata), sourceMetadata (for alias tables, source table metadata in sourceTable.metadata; works across projects for linked buckets), sourceColumnMetadata (for alias tables, source column metadata in sourceTable.columnMetadata).

Response

Bucket detail.

uristring required

API URI of the bucket.

idstring required

Bucket identifier ({stage}.{name}).

namestring required

Bucket name (prefixed with c-).

displayNamestring required

Human-readable display name shown in the UI.

idBranchinteger required

ID of the branch the bucket belongs to.

stage'in' | 'out' | 'sys' required

Bucket stage.

descriptionstring required

Bucket description.

createdstring required

Creation timestamp, ISO 8601 with a +hhmm offset; "" when none was recorded.

lastChangeDatestring nullable required

Timestamp of the last data change in the bucket, ISO 8601 with a +hhmm offset.

updatedstring nullable required

Timestamp of the last bucket update, ISO 8601 with a +hhmm offset.

isReadOnlyboolean required

Whether the bucket is read-only (linked or external buckets).

dataSizeBytesinteger required

Total data size in bytes.

rowsCountinteger required

Total number of rows.

isMaintenanceboolean required

Whether the bucket is in maintenance mode.

backendstring required

Storage backend of the bucket: snowflake, bigquery or postgres (external buckets); older buckets may carry another backend name.

sharing'organization' | 'organization-project' | 'specific-projects' | 'specific-users' | 'null' nullable required

Sharing type of the bucket; null when the bucket is not shared.

hasExternalSchemaboolean required

Whether the bucket is an external (registered) bucket.

databaseNamestring required

Database of a Snowflake external bucket or of a linked bucket's source; "" otherwise.

pathstring required

Dot-separated path of the bucket on the backend.

isSnowflakeSharedDatabaseboolean required

Whether the external bucket uses a Snowflake Secure Data Share.

isLinkedBucketboolean required

Whether this bucket is linked from another project.

colorstring nullable required

CSS color of the bucket.

bucketSharingAllowedboolean required

Whether the bucket can be shared.

backendPathstring[] required

Full path of the bucket on the backend (e.g. database and schema); [] on backends without one.

attributesobject[] required

Deprecated, always an empty array. Kept for backward compatibility.

Example response

{
  "uri": "https://connection.keboola.com/v2/storage/buckets/in.c-my-new-bucket",
  "id": "in.c-my-new-bucket",
  "name": "c-my-new-bucket",
  "displayName": "my-new-bucket",
  "idBranch": 1234,
  "stage": "in",
  "description": "Some Description",
  "tables": [
    {
      "created": "2017-02-13T12:01:05+0100",
      "lastImportDate": "2017-02-13T12:01:05+0100",
      "lastChangeDate": "2017-02-13T12:01:05+0100",
      "bucket": {
        "uri": "https://connection.keboola.com/v2/storage/buckets/in.c-my-new-bucket",
        "id": "in.c-my-new-bucket",
        "name": "c-my-new-bucket",
        "displayName": "my-new-bucket",
        "idBranch": 1234,
        "stage": "in",
        "description": "Some Description",
        "tables": "https://connection.keboola.com/v2/storage/buckets/in.c-my-new-bucket",
        "created": "2017-02-13T12:01:05+0100",
        "updated": "2024-11-28T13:03:13+0100",
        "backend": "snowflake",
        "path": "database_name.c-my-new-bucket",
        "bucketSharingAllowed": true,
        "sharingParameters": {
          "projects": [
            {
              "id": 321,
              "name": "Some Project"
            }
          ],
          "users": [
            {
              "id": 5,
              "name": "Jan Developer",
              "email": "jan.dev@keboola.com"
            }
          ]
        },
        "sharedBy": {
          "id": 5,
          "name": "dev@keboola.com",
          "date": "2020-02-03T14:58:29+0100"
        },
        "owner": {
          "id": 123,
          "name": "Jan Developer",
          "email": "jan.dev@keboola.com"
        },
        "sourceBucket": {
          "id": "in.c-main",
          "name": "c-main",
          "displayName": "main",
          "stage": "in",
          "description": "Organization shared data",
          "sharing": "organization-project",
          "created": "2020-01-12T18:28:31+0100",
          "lastChangeDate": "2020-01-12T18:31:49+0100",
          "dataSizeBytes": 1536,
          "rowsCount": 32,
          "backend": "snowflake",
          "path": "database_name.c-main",
          "project": {
            "id": 123,
            "name": "Project name"
          },
          "tables": [
            {
              "id": "in.c-main.languages",
              "name": "languages",
              "displayName": "languages-display-name",
              "path": "/1234-languages"
            }
          ],
          "sharingParameters": {
            "projects": [
              {
                "id": 321,
                "name": "Some Project"
              }
            ],
            "users": [
              {
                "id": 5,
                "name": "Jan Developer",
                "email": "jan.dev@keboola.com"
              }
            ]
          },
          "sharedBy": {
            "id": 5,
            "name": "dev@keboola.com",
            "date": "2020-02-03T14:58:29+0100"
          },
          "owner": {
            "id": 123,
            "name": "Jan Developer",
            "email": "jan.dev@keboola.com"
          },
          "metadata": [
            {
              "id": "19509",
              "key": "some-key",
              "value": "Some value",
              "provider": "test-component",
              "timestamp": "2017-02-13T23:36:10+0100"
            }
          ]
        },
        "backendPath": [
          "KBC_PRJ_123",
          "in.c-my-new-bucket"
        ],
        "metadata": [
          {
            "id": "19509",
            "key": "some-key",
            "value": "Some value",
            "provider": "test-component",
            "timestamp": "2017-02-13T23:36:10+0100"
          }
        ]
      },
      "metadata": [
        {
          "id": "19509",
          "key": "some-key",
          "value": "Some value",
          "provider": "test-component",
          "timestamp": "2017-02-13T23:36:10+0100"
        }
      ],
      "sourceTable": {
        "metadata": [
          {
            "id": "19509",
            "key": "some-key",
            "value": "Some value",
            "provider": "test-component",
            "timestamp": "2017-02-13T23:36:10+0100"
          }
        ]
      }
    }
  ],
  "created": "2017-02-13T12:01:05+0100",
  "updated": "2024-11-28T13:03:13+0100",
  "backend": "snowflake",
  "path": "database_name.c-my-new-bucket",
  "bucketSharingAllowed": true,
  "sharingParameters": {
    "projects": [
      {
        "id": 321,
        "name": "Some Project"
      }
    ],
    "users": [
      {
        "id": 5,
        "name": "Jan Developer",
        "email": "jan.dev@keboola.com"
      }
    ]
  },
  "sharedBy": {
    "id": 5,
    "name": "dev@keboola.com",
    "date": "2020-02-03T14:58:29+0100"
  },
  "owner": {
    "id": 123,
    "name": "Jan Developer",
    "email": "jan.dev@keboola.com"
  },
  "sourceBucket": {
    "id": "in.c-main",
    "name": "c-main",
    "displayName": "main",
    "stage": "in",
    "description": "Organization shared data",
    "sharing": "organization-project",
    "created": "2020-01-12T18:28:31+0100",
    "lastChangeDate": "2020-01-12T18:31:49+0100",
    "dataSizeBytes": 1536,
    "rowsCount": 32,
    "backend": "snowflake",
    "path": "database_name.c-main",
    "project": {
      "id": 123,
      "name": "Project name"
    },
    "tables": [
      {
        "id": "in.c-main.languages",
        "name": "languages",
        "displayName": "languages-display-name",
        "path": "/1234-languages"
      }
    ],
    "sharingParameters": {
      "projects": [
        {
          "id": 321,
          "name": "Some Project"
        }
      ],
      "users": [
        {
          "id": 5,
          "name": "Jan Developer",
          "email": "jan.dev@keboola.com"
        }
      ]
    },
    "sharedBy": {
      "id": 5,
      "name": "dev@keboola.com",
      "date": "2020-02-03T14:58:29+0100"
    },
    "owner": {
      "id": 123,
      "name": "Jan Developer",
      "email": "jan.dev@keboola.com"
    },
    "metadata": [
      {
        "id": "19509",
        "key": "some-key",
        "value": "Some value",
        "provider": "test-component",
        "timestamp": "2017-02-13T23:36:10+0100"
      }
    ]
  },
  "backendPath": [
    "KBC_PRJ_123",
    "in.c-my-new-bucket"
  ],
  "attributes": [],
  "metadata": [
    {
      "id": "19509",
      "key": "some-key",
      "value": "Some value",
      "provider": "test-component",
      "timestamp": "2017-02-13T23:36:10+0100"
    }
  ],
  "scheduledTasks": [
    {
      "uuid": "0197e22b-379d-7c62-bc6d-88e50c3d0c75",
      "job": "bucketRefresh",
      "relatedEntity": "bucket",
      "relatedId": "in.c-bucket-name",
      "cronExpression": "42 13 * * *",
      "createdAt": "2025-07-01T00:08:00+02:00"
    }
  ],
  "linkedBy": [
    {
      "id": "in.c-linked-bucket",
      "created": "2017-02-13T12:01:05+0100",
      "project": {
        "id": "321",
        "name": "Some Project"
      }
    }
  ]
}

Changes

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