---
title: "List bucket listings"
method: GET
path: "/v2/storage/branch/{branchId}/listings"
tags: ["Buckets"]
---

# List bucket listings

`GET /v2/storage/branch/{branchId}/listings`

## Request

- Base URL: `https://connection.keboola.com`
- URL: `https://connection.keboola.com/v2/storage/branch/{branchId}/listings`
- Auth: one of:
  - API key in header `X-StorageApi-Token`
  - API key in header `X-KBC-ManageApiToken`
  - HTTP bearer
- TypeScript: <https://skmtc.dev/keboola/apis/keboola-storage-api/docs/v2/storage/branch/:branchId/listings/get.ts> (a function with typed inputs; its response is checked against the schema)

Lists all bucket exposures (BigQuery Analytics Hub listings) in the project or development branch. Returns an empty array when no listings exist. The endpoint is BigQuery-only; Snowflake Partner Connect projects receive a 501 response. Each row mirrors the per-bucket `GET /v2/storage/buckets/{bucketId}/listing` response and additionally carries the source `bucketId` so the listing can be cross-referenced without a second call. Data is read from the database - no backend API call is performed.

## Path parameters

- `branchId` string, required

## Response `200`

List of bucket listings the token has manage privilege on.

- ProjectBucketListingResponse[]
  - `bucketId` string, required: Identifier of the bucket the listing is attached to.
  - `name` string, required: Human-readable listing name (used as the backend listing displayName).
  - `description` string: Listing description. Present only when one is set.
  - `backend` 'bigquery' | 'snowflake', required: Backend of the listed bucket.
  - `bigquery` BigQueryBucketListingDetailResponse
    - `listingId` string, required: User-defined listing ID (unique within the exchange).
    - `listingResourceName` string: GCP listing resource name. Omitted from the response when the listing has not yet been provisioned (the async job is still running or has failed).
    - `subscribers` string[], required: IAM principals with subscriber access (each prefixed with `user:` or `group:`).
  - `snowflake` SnowflakeBucketListingDetailResponse
    - `mode` 'grant' | 'share', required: `grant`: roles in the backend's account read the bucket schema. `share`: other accounts read it through a Snowflake share.
    - `grantees` string[]: Grantee roles, upper case. Present only in `grant` mode.
    - `accounts` string[]: Consumer accounts (`<ORGANIZATION>.<ACCOUNT>`), upper case. Present only in `share` mode.
    - `objectName` string, nullable, required: Quoted name of the exposed object: `"<DATABASE>"."<SCHEMA>"` in `grant` mode, the share name in `share` mode. Null until the create job has provisioned the exposure.
  - `createdAt` string, date-time, required: Listing creation timestamp.

## Other responses

- `501`: Bucket listings are not supported on Snowflake Partner Connect projects (`storage.buckets.notSupportedForSPCProject`).

---

[API](https://skmtc.dev/keboola/apis/keboola-storage-api.md) - [All operations](https://skmtc.dev/keboola/apis/keboola-storage-api/llms.txt) - [OpenAPI document](https://skmtc.dev/keboola/apis/keboola-storage-api/revisions/34b5ceac0317?raw)
