KEkeboola
Tables

List all tables

Lists all tables accessible by the token. By default, all tables are returned with their attributes and information about the containing bucket. Use the include query parameter to add columns, metadata, column metadata or (for aliases) source table metadata to each item.

get/v2/storage/tables

Request

Query parameters

includestring nullable

Comma-separated list of data to include. Allowed values: attributes, buckets, bucketsWithoutSourceTables, columns, metadata, columnMetadata, sourceMetadata, sourceColumnMetadata. Default: attributes,buckets.

Response

List of tables.

uristring required

Table detail URI

idstring required

Table identifier

namestring required

Table name

displayNamestring required

Display name of the table

transactionalboolean required

Transactional flag

primaryKeystring[] required
indexTypestring nullable required
indexKeystring[] required
distributionTypestring nullable required
distributionKeystring[] required
syntheticPrimaryKeyEnabledboolean required
createdstring nullable required

Created timestamp, ISO 8601 with a +hhmm offset.

lastImportDatestring nullable required

Last import date, ISO 8601 with a +hhmm offset.

lastChangeDatestring nullable required

Last change date, ISO 8601 with a +hhmm offset.

rowsCountinteger nullable required
dataSizeBytesinteger nullable required
isAliasboolean required
isAliasableboolean required
isTypedboolean required
isDescriptionSystemManagedboolean required

True when the table description is managed by the system.

timestampType'MANAGED' | 'SELFMANAGED' | 'NONE' required

How the _timestamp column is managed.

tableTypestring required
pathstring required
attributesobject[]

Always an empty array, kept for backward compatibility. Present with include=attributes (the default).

columnsstring[]

Column names. Present with include=columns.

columnMetadataTableColumnMetadataResponse

Column metadata of a table, keyed by column name. Built by Model_Row_MetadataTable::getTableColumnMetadataApiResponse().

aliasColumnsAutoSyncboolean

Present only for simple aliases.

selectSqlstring

Present only for custom SQL aliases.

isPersistedboolean

Whether the alias is persisted as a table in the backend. Present only for alias tables.

Example response

[
  {
    "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"
        }
      ]
    }
  }
]

Changes

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