---
title: "Update BI Column"
method: PUT
path: "/data/projects/{projectId}/bitable/{tableName}/columns/{columnName}"
tags: ["Data -- Internal Tables"]
---

# Update BI Column

`PUT /data/projects/{projectId}/bitable/{tableName}/columns/{columnName}`

## Request

- Base URL: `https://partner.peaka.studio/api/v1`
- URL: `https://partner.peaka.studio/api/v1/data/projects/{projectId}/bitable/{tableName}/columns/{columnName}`
- Auth: HTTP bearer

Updates the definition of an existing column in the specified [Peaka BI Table](https://docs.peaka.com/connecting-your-data/peaka-bi-table). Allows modifying the column's name, display name, data type, default value, and constraints such as nullability and uniqueness.

## Path parameters

- `projectId` string, required
- `tableName` string, required
- `columnName` string, required

## Request body

- ColumnRequest: ColumnRequest is used to create, update, display a column in a table. It contains the name, data type, display name, default value, not null and unique status of the column request.
  - `name` string: The name of the column.
  - `dataType` 'VARCHAR' | 'BIGINT' | 'BOOLEAN' | 'DECIMAL' | 'TIMESTAMP' | 'TIME' | 'DATE' | 'UUID': The data type of the column.
  - `displayName` string: The display name of the column.
  - `defaultValue` string: The default value of the column.
  - `isNotNull` boolean: The not null flag for the column.
  - `isUnique` boolean: The unique flag for the column.

## Response `200`

OK

---

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