Pre-warm a new table for on-demand capacity mode 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 then choose Create table.

On the Create table page in the Table details section, select a keyspace and provide a name for the new table.

In the Columns section, create the schema for your table.

In the Primary key section, define the primary key of the table and select optional clustering columns.

In the Table settings section, choose Customize settings.

Continue to Read/write capacity settings.

For Capacity mode, choose Provisioned.

In the Read capacity section, deselect Scale automatically.

Set the table's Provisioned capacity units to the expected peak value.

In the Write capacity section, choose the same settings as defined in the previous step for read capacity, or configure capacity values manually.

Choose Create table. Your table is getting created with the specified capacity settings.

When the table's status turns to Active, you can switch the table to On-demand capacity mode.

Create a new table in provisioned mode and specify the expected peak capacity for reads and writes for the new table. The following statement is an example of this.

CREATE TABLE catalog.book_awards (
   year int,
   award text,
   rank int, 
   category text,
   book_title text,
   author text, 
   publisher text,
   PRIMARY KEY ((year, award), category, rank))
WITH CUSTOM_PROPERTIES = {  
    'capacity_mode': {  
        'throughput_mode': 'PROVISIONED',  
        'read_capacity_units': 18000,  
        'write_capacity_units': 6000  
     }
};

Confirm the status of the table. You can use the following statement.

SELECT keyspace_name, table_name, status FROM system_schema_mcs.tables WHERE keyspace_name = 'catalog' AND table_name = 'book_awards';

 keyspace_name | table_name      | status
---------------+-----------------+--------
       catalog | book_awards     | ACTIVE

(1 rows)

When the table's status is ACTIVE, you can use the following statement to change the capacity mode of the table to on-demand mode by setting the throughput mode to PAY_PER_REQUEST. The following statement is an example of this.

ALTER TABLE catalog.book_awards WITH CUSTOM_PROPERTIES={'capacity_mode':{'throughput_mode': 'PAY_PER_REQUEST'}};

You can use the following statement to confirm that the table is now in on-demand mode and see the table's status.

SELECT * from system_schema_mcs.tables where keyspace_name = 'catalog' and table_name = 'book_awards';

Create a new table in provisioned mode and specify the expected peak capacity values for reads and writes for the new table. The following statement is an example of this.

aws keyspaces create-table --keyspace-name catalog --table-name book_awards 
                                    \--schema-definition 'allColumns=[{name=pk,type=int},{name=ck,type=int}],partitionKeys=[{name=pk},{name=ck}]'  
                                    \--capacity-specification throughputMode=PROVISIONED,readCapacityUnits=18000,writeCapacityUnits=6000 

Confirm the status of the table. You can use the following statement.

aws keyspaces get-table --keyspace-name catalog --table-name book_awards

When the table is active and the capacity has been provisioned, you can change the table to on-demand mode. The following is an example of this.

aws keyspaces update-table --keyspace-name catalog --table-name book_awards --capacity-specification throughputMode=PAY_PER_REQUEST

You can use the following statement to confirm that the table is now in on-demand mode and see the table's status.

aws keyspaces get-table --keyspace-name catalog --table-name book_awards