Configure PITR for a table in Amazon Keyspaces

Sign in to the Amazon Web Services Management Console, and open the Amazon Keyspaces console at https://console.amazonaws.cn/keyspaces/home.

In the navigation pane, choose Tables and select the table you want to edit.

On the Backups tab, choose Edit.

In the Edit point-in-time recovery settings section, select Enable Point-in-time recovery.

Choose Save changes.

You can manage PITR settings for tables by using the point_in_time_recovery custom property.

To enable PITR when you're creating a new table, you must set the status of point_in_time_recovery to enabled. You can use the following CQL command as an example.

CREATE TABLE "my_keyspace1"."my_table1"(
	"id" int,
	"name" ascii,
	"date" timestamp,
	PRIMARY KEY("id"))
WITH CUSTOM_PROPERTIES = {
	'capacity_mode':{'throughput_mode':'PAY_PER_REQUEST'}, 
	'point_in_time_recovery':{'status':'enabled'}
}

To enable PITR for an existing table using CQL, run the following CQL command.

ALTER TABLE mykeyspace.mytable
WITH custom_properties = {'point_in_time_recovery': {'status': 'enabled'}}

You can manage PITR settings for tables by using the UpdateTable API.

To enable PITR when you're creating a new table, you must include point-in-time-recovery 'status=ENABLED' in the create table command. You can use the following Amazon CLI command as an example. The command has been broken into separate lines to improve readability.

aws keyspaces create-table --keyspace-name 'myKeyspace' --table-name 'myTable' 
            --schema-definition 'allColumns=[{name=id,type=int},{name=name,type=text},{name=date,type=timestamp}],partitionKeys=[{name=id}]' 
            --point-in-time-recovery 'status=ENABLED'

To confirm the point-in-time recovery setting for a table, you can use the following Amazon CLI command.

aws keyspaces get-table --keyspace-name 'myKeyspace' --table-name 'myTable'

To enable PITR for an existing table using the Amazon CLI, run the following command.

aws keyspaces update-table --keyspace-name 'myKeyspace' --table-name 'myTable' --point-in-time-recovery 'status=ENABLED'