---
title: "Lists every grantable ClickHouse database with its members and agent ceiling."
method: GET
path: "/authorization/relations/clickhouse"
tags: ["ClickHouse"]
---

# Lists every grantable ClickHouse database with its members and agent ceiling.

`GET /authorization/relations/clickhouse`

## Request

- Base URL: `https://api.rapidata.ai`
- URL: `https://api.rapidata.ai/authorization/relations/clickhouse`
- Auth: OpenID Connect (`https://auth.rapidata.ai/.well-known/openid-configuration`, scopes: `openid`, `profile`, `email`, `offline_access`, `api`)

Databases with no grants are included, with no members and a None ceiling.

## Response `200`

OK

- GetClickHouseAccessEndpointOutput[]
  - `database` string, required: The ClickHouse database name.
  - `members` GetClickHouseAccessEndpointMember[], required: The customers holding a relation on the database.
    - `customer` string, uuid, required
    - `email` string, required
    - `relation` 'Reader' | 'Writer', required: Relations a customer holds on a `clickhouse_database`, one object per ClickHouse database name. `writer` folds into `reader`.
  - `agentCeiling` 'None' | 'Reader' | 'Writer', required: The most an `agent` may do on a `clickhouse_database`, whoever it acts for. ClickHouseAgentCeiling.None means no agent tuple exists on the database.

## Other responses

- `400`: Bad Request
- `401`: Unauthenticated
- `403`: Forbidden

## Changes

- **2026-10-23** `3cf7b4f0003e`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/rapidata/apis/rapidata-api/changes/authorization/relations/clickhouse/get.md)

---

[API](https://skmtc.dev/rapidata/apis/rapidata-api.md) - [All operations](https://skmtc.dev/rapidata/apis/rapidata-api/llms.txt) - [OpenAPI document](https://skmtc.dev/rapidata/apis/rapidata-api/revisions/004a977d7d9f?raw)