Posted On: Mar 3, 2021

Amazon Keyspaces (for Apache Cassandra), a scalable, highly available, and fully managed Cassandra-compatible database service, now helps you update and store common data between multiple rows efficiently by using static columns. 

By using static columns, you can define a common column value for all rows in a logical partition. When you insert, update, or delete the value of a static column, the change applies to all rows in the logical partition automatically. For example, you can use a static column to store the text description of a unique identifier in your partition key, such as a customer, product, or device code. You then would have to perform only one write to update or delete this text description instead of coordinating writes across multiple rows. Static columns also help you store common data more efficiently and reduce costs by storing a single copy of the data for all rows in the logical partition. 

Support for static columns is available in the Amazon Web Services China (Beijing) Region, operated by Sinnet, and the Amazon Web Services China (Ningxia) Region, operated by NWCD.

For information, see How it Works in the Amazon Keyspaces Developer Guide.