Posted On: Feb 25, 2020

Amazon Managed Apache Cassandra Service (MCS), a scalable, highly available, and managed Apache Cassandra–compatible database service, now enables you to add new columns to existing tables. 

Using the ALTER TABLE Cassandra Query Language (CQL) statement, you now can add new columns to existing tables as you develop or test applications, or as your data requirements evolve over time. For example, you can use ALTER TABLE to add a new column to a user profile table to store additional data about users. The ALTER TABLE statement also enables you to change table properties, such as provisioned capacity settings. 

Support for adding columns to existing tables is available in all AWS Regions where Amazon MCS is offered. Amazon MCS is available in preview in the US East (N. Virginia), US East (Ohio), EU (Stockholm), Asia Pacific (Tokyo), and Asia Pacific (Singapore) Regions. 

For more information about how to add columns to existing tables and change table properties, see DDL Statements (Data Definition Language) in the Amazon MCS Developer Guide