Working with Amazon Keyspaces (for Apache Cassandra) features

Time to Live – Amazon Keyspaces expires data from tables automatically based on the Time to Live value you set. Learn how to configure TTL and how to use it in your tables.

PITR – Protect your Amazon Keyspaces tables from accidental write or delete operations by creating continuous backups of your table data. Learn how to configure PITR on your tables and how to restore a table to a specific point in time or how to restore a table that has been accidentally deleted.

Working with multi-Region tables – Multi-Region tables in Amazon Keyspaces must have write throughput capacity configured in either on-demand or provisioned capacity mode with auto scaling. Plan the throughput capacity needs by estimating the required write capacity units (WCUs) for each Region, and provision the sum of writes from all Regions to ensure sufficient capacity for replicated writes.

Static columns – Amazon Keyspaces handles static columns differently from regular columns. This section covers calculating the encoded size of static columns, metering read/write operations on static data, and guidelines for working with static columns.

Queries and pagination – Amazon Keyspaces supports advanced querying capabilities like using the IN operator with SELECT statements, ordering results with ORDER BY, and automatic pagination of large result sets. This section explains how Amazon Keyspaces processes these queries and provides examples.

Partitioners – Amazon Keyspaces provides three partitioners: Murmur3Partitioner (default), RandomPartitioner, and DefaultPartitioner. You can change the partitioner per Region at the account level using the Amazon Web Services Management Console or Cassandra Query Language (CQL).

Client-side timestamps – Client-side timestamps are Cassandra-compatible timestamps that Amazon Keyspaces persists for each cell in your table. Use client-side timestamps for conflict resolution and to let your client application determine the order of writes.

Tagging resources – You can label Amazon Keyspaces resources like keyspaces and tables using tags. Tags help categorize resources, enable cost tracking, and let you configure access control based on tags. This section covers tagging restrictions, operations, and best practices for Amazon Keyspaces.

Amazon CloudFormation templates – Amazon CloudFormation helps you model and set up your Amazon Keyspaces keyspaces and tables so that you can spend less time creating and managing your resources and infrastructure.