---
title: "POST /schema/tables/{table}/columns"
method: POST
path: "/schema/tables/{table}/columns"
---

# POST /schema/tables/{table}/columns

`POST /schema/tables/{table}/columns`

add a single column to existing table

## Path parameters

- `table` string, required

## Request body

- object
  - `caseInsensitive` boolean — Whether to compare characters case insensitively for enum columns. It only matters for ingestion client as it's the place to concert enum strings to enum values.
  - `config` ColumnConfig — ColumnConfig defines the schema of a column config that can be mutated by UpdateColumn API call.
    - `preloadingDays` integer — ColumnEvictionConfig : For column level in-memory eviction, it’s the best effort TTL for in-memory data. Column level eviction has nothing to do with data availability, but based on how much data we pre-loaded, the major impact will be there for query performance. Here we bring in two priorities configs: Preloading days and Priority. Preloading days is defined at each column level to indicate how many recent days data we want to preload to host memory. This is best effort operation. Priority is defined at each column level to indicate the priority of each column. When data eviction happens, we will rely on column priority to decide which column will be evicted first. High number implies high priority.
    - `priority` integer
  - `defaultValue` string — We store the default value as string here since it's from user input. Nil means the default value is NULL. Actual default value of column data type should be stored in memstore.
  - `deleted` boolean — Deleted columns are kept as placeholders in Table.Columns.
  - `disableAutoExpand` boolean — Whether disable enum cases auto expansion.
  - `name` string — Immutable, columns cannot be renamed.
  - `type` string — Immutable, columns cannot have their types changed.
  - `addToArchivingSortOrder` boolean

## Response `200`

NoContentResponse represents Response with no content.

## Other responses

- `default` — ErrorResponse represents error response.

---

[API](https://skmtc.net/uber/apis/provide-the-restful-apis-to-interact-with-aresdb.md) · [All operations](https://skmtc.net/uber/apis/provide-the-restful-apis-to-interact-with-aresdb/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/uber/provide-the-restful-apis-to-interact-with-aresdb/versions/d18a58e88958/schema)