> ## Documentation Index > Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Update ClickHouse settings > **Disclaimer:** This beta endpoint is evolving; the API contract may change.

Updates one or more ClickHouse settings for the service. To reset a setting to its platform default, use the [DELETE single setting](/products/cloud/api-reference/service/service-clickhouse-setting-delete) endpoint. Use the [schema endpoint](/products/cloud/api-reference/service/service-clickhouse-settings-schema-get) to discover which settings are configurable. Beta **Disclaimer:** This beta endpoint is evolving; the API contract may change.

Updates one or more ClickHouse settings for the service. To reset a setting to its platform default, use the [DELETE single setting](/products/cloud/api-reference/service/service-clickhouse-setting-delete) endpoint. Use the [schema endpoint](/products/cloud/api-reference/service/service-clickhouse-settings-schema-get) to discover which settings are configurable.

Permission

The API key must have the `control-plane:service:manage` permission.
## OpenAPI ````yaml _specs/cloud-openapi.json PATCH /v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings openapi: 3.1.1 info: title: OpenAPI spec for ClickHouse Cloud version: '1.0' contact: name: ClickHouse Support url: >- https://clickhouse.com/docs/en/cloud/manage/openapi?referrer=openapi-1222280 email: support@clickhouse.com servers: - url: https://api.clickhouse.cloud security: - basicAuth: [] tags: - name: Organization - name: Notifications - name: User management - name: Billing - name: Role Management - name: Service - name: Backup - name: Snapshot - name: API keys - name: Prometheus - name: ClickPipes - name: ClickStack - name: Postgres - name: UDF - name: Query API endpoints - name: Saved queries paths: /v1/organizations/{organizationId}/services/{serviceId}/clickhouseSettings: patch: tags: - Service summary: Update ClickHouse settings description: >- **Disclaimer:** This beta endpoint is evolving; the API contract may change.

Updates one or more ClickHouse settings for the service. To reset a setting to its platform default, use the [DELETE single setting](#tag/Service/operation/serviceClickhouseSettingDelete) endpoint. Use the [schema endpoint](#tag/Service/operation/serviceClickhouseSettingsSchemaGet) to discover which settings are configurable. operationId: serviceClickhouseSettingsUpdate parameters: - in: path name: organizationId description: ID of the organization that owns the service. required: true schema: type: string format: uuid - in: path name: serviceId description: ID of the service. required: true schema: type: string format: uuid requestBody: content: application/json: schema: $ref: '#/components/schemas/ServiceClickhouseSettingsPatchRequest' responses: '200': description: Successful response content: application/json: schema: type: object properties: status: type: number description: HTTP status code. example: 200 requestId: type: string description: Unique id assigned to every request. UUIDv4 format: uuid result: $ref: >- #/components/schemas/ServiceClickhouseSettingsPatchResponse '400': description: >- The request cannot be processed due to a client error. Please verify your request parameters and try again. content: application/json: schema: type: object properties: status: type: number description: HTTP status code. example: 400 error: type: string description: Detailed error description. requestId: type: string description: Unique id assigned to every request. UUIDv4 format: uuid '500': description: >- An internal server error has occurred. If this issue persists, please contact ClickHouse Cloud support for assistance. content: application/json: schema: type: object properties: status: type: integer description: HTTP status code. example: 500 error: type: string description: Detailed error description. requestId: type: string description: Unique id assigned to every request. UUIDv4 format: uuid components: schemas: ServiceClickhouseSettingsPatchRequest: properties: settings: $ref: '#/components/schemas/ServiceClickhouseSettingsMap' required: - settings ServiceClickhouseSettingsPatchResponse: properties: settings: $ref: '#/components/schemas/ServiceClickhouseSettingsMap' warnings: type: array description: Warnings for settings that may have disruptive effects. items: $ref: '#/components/schemas/ServiceClickhouseSettingWarning' ServiceClickhouseSettingsMap: type: object description: >- Nonempty object mapping configurable setting names to their values. Use DELETE to reset a setting. minProperties: 1 additionalProperties: $ref: '#/components/schemas/ServiceClickhouseSettingValue' example: compatibility: '26.2' max_query_size: 262144 ServiceClickhouseSettingWarning: properties: name: description: Name of the setting the warning applies to. type: string example: compatibility message: description: Warning message. type: string example: >- Changing the compatibility version without comprehensive testing can cause query failures or instability. ServiceClickhouseSettingValue: description: >- Setting value in its native JSON type. Use the settings schema endpoint for per-setting constraints. oneOf: - type: string - type: integer example: '26.2' securitySchemes: basicAuth: type: http scheme: basic description: >- Use key ID and key secret obtained in ClickHouse Cloud console: https://clickhouse.com/docs/cloud/manage/openapi x-permission-scopes: >- The scope list of a `security` requirement holds ClickHouse Cloud API key permission ids (for example `control-plane:organization:view`), not OAuth scopes. OpenAPI has no field for API key permissions, so this is the closest available place. A key must hold every permission listed on an operation to call it; an operation with no scopes needs none beyond a valid key. Every operation declares at most one requirement object, always for this scheme, so the list is only ever conjunctive — alternative sets of permissions are never expressed. ````