---
title: "Get Catalog Column By Params"
method: GET
path: "/catalog/get-columns-by-table"
tags: ["catalog"]
---

# Get Catalog Column By Params

`GET /catalog/get-columns-by-table`

## Query parameters

- `account_id` string, required
- `region` string, required
- `database_type` string, required
- `database_name` string, required
- `table_name` string, required
- `page` integer
- `size` integer

## Response `200`

Successful Response

- BaseResponsePageCatalogColumnLevelClassification
  - `status` string, required
  - `code` integer, required
  - `message` string
  - `data` PageCatalogColumnLevelClassification
    - `items` CatalogColumnLevelClassification[], required
      - `id` integer, required
      - `account_id` string, required
      - `region` string, required
      - `database_type` string, required
      - `database_name` string, required
      - `table_name` string, required
      - `column_name` string, required
      - `column_type` string, required
      - `column_order_num` integer, required
      - `column_value_example` string
      - `identifier` string
      - `identifier_score` number
      - `privacy` integer
      - `sensitivity` string, required
      - `comments` string
      - `manual_tag` string
      - `job_keyword` string
      - `column_path` string
      - `state` string
      - `version` integer
      - `create_by` string
      - `create_time` string, date-time
      - `modify_by` string
      - `modify_time` string, date-time
    - `total` integer, required
    - `page` integer
    - `size` integer
    - `pages` integer

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.net/aws-samples/apis/sensitive-data-protect-solution.md) · [All operations](https://skmtc.net/aws-samples/apis/sensitive-data-protect-solution/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aws-samples/sensitive-data-protect-solution/versions/e0c2e29932e2/schema)