---
title: "Get Golden Sqls"
method: GET
path: "/golden-sqls"
tags: ["Golden SQL"]
---

# Get Golden Sqls

`GET /golden-sqls`

## Request

- The document declares no server URL.
- Auth: HTTP bearer

## Query parameters

- `page` integer
- `page_size` integer
- `order` string
- `ascend` boolean

## Response `200`

Successful Response

- AdminConsoleGoldenSqlResponse[]
  - `db_connection_id` string, required
  - `prompt_text` string, required
  - `sql` string, required
  - `id` string, required
  - `created_at` string, date-time
  - `metadata` GoldenSQLMetadata
    - `dh_internal` DHGoldenSQLMetadata
      - `prompt_id` string
      - `organization_id` string
      - `source` 'USER_UPLOAD' | 'VERIFIED_QUERY': An enumeration.
      - `display_id` string

## Other responses

- `404`: Not found
- `422`: Validation Error

---

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