Skip to main content
Version: v2.5 print this page

Alter Schema

Alter Schema functionality allows user to alter the schema of datasets. the following operations are supported:

  • Add Column
  • Rename Column
  • Change Column Data Type
  • Change Column Description
  • Drop Column
Note
  • Alter Schema functionality is only applicable for s3athena, lakeformation(Non Hudi) and Redshift type of datasets

Add Column

Add Column

Note
  • For iceberg and redshift datasets, only one column can be added in a single request

Rename Column

Rename Column

Change Column Data Type

Change Column DataType

Change Column Description

Update Column Description

Note
  • The maximum length for the column description is 255 characters

Drop Column

Drop Column

Note
  • For iceberg and redshift datasets, only one column can be dropped in a single request
  • Drop Column is not applicable for lakeformation datasets with data filters