---
title: "Saved Sql Queries List Partial Update"
method: PATCH
path: "/clickhouse/saved-sql-queries/list/"
tags: ["clickhouse"]
---

# Saved Sql Queries List Partial Update

`PATCH /clickhouse/saved-sql-queries/list/`

PATCH handler with superadmin lock and field protection.

Checks:
1. Object lock (is_managed=True -> non-superadmins can't modify)
2. Field protection (non-superadmins can't modify specific fields)

## Headers

- `Authorization` string, required

## Request body

- PatchedSavedSQLQueryListRequest
  - `name` string
  - `description` string
  - `query` string
  - `plotting_config` union
    - unknown
    - unknown
  - `source` 'sql_editor' | 'dashboard_custom_chart' — * `sql_editor` - SQL editor * `dashboard_custom_chart` - Dashboard custom chart

## Response `200`

- SavedSQLQueryList
  - `id` string, required
  - `name` string, required
  - `description` string
  - `query` string, required
  - `plotting_config` union
    - unknown
    - unknown
  - `source` 'sql_editor' | 'dashboard_custom_chart' — * `sql_editor` - SQL editor * `dashboard_custom_chart` - Dashboard custom chart
  - `project` string, required
  - `created_at` string, date-time, required
  - `updated_at` string, date-time, required
  - `created_by` Editor, required
    - `id` integer, required
    - `email` string, required
    - `name` string, required
    - `username` string
    - `first_name` string
    - `last_name` string

---

[API](https://skmtc.net/keywordsai/apis/api-reference.md) · [All operations](https://skmtc.net/keywordsai/apis/api-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/keywordsai/api-reference/versions/c26d550029f8/schema)