---
title: "Sets the agent ceiling on a ClickHouse database; an agent gets the lesser of this and its owner's access."
method: PUT
path: "/authorization/relations/clickhouse/agent"
tags: ["ClickHouse"]
---

# Sets the agent ceiling on a ClickHouse database; an agent gets the lesser of this and its owner's access.

`PUT /authorization/relations/clickhouse/agent`

## Request

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

None denies agents the database. Idempotent. 400 when the database is not grantable.

## Request body

- SetClickHouseAgentCeilingEndpointInput
  - `database` string, required: The ClickHouse database name.
  - `ceiling` '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.

## Response `204`

No Content

## 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/agent/put.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)