View the capacity mode of a table in Amazon Keyspaces

You can query the system table in the Amazon Keyspaces system keyspace to review capacity mode information about a table. You can also see whether a table is using on-demand or provisioned throughput capacity mode. If the table is configured with provisioned throughput capacity mode, you can see the throughput capacity provisioned for the table.

Example

SELECT * from system_schema_mcs.tables where keyspace_name = 'mykeyspace' and table_name = 'mytable';

A table configured with on-demand capacity mode returns the following.

                    {
                        'capacity_mode': {
                            'last_update_to_pay_per_request_timestamp': '1579551547603',
                            'throughput_mode': 'PAY_PER_REQUEST'
                         }
                    }                    
                

A table configured with provisioned throughput capacity mode returns the following.

                    {
                        'capacity_mode': {
                            'last_update_to_pay_per_request_timestamp': '1579048006000', 
                            'read_capacity_units': '5000', 
                            'throughput_mode': 'PROVISIONED', 
                            'write_capacity_units': '6000'
                        }
                     }
                

The last_update_to_pay_per_request_timestamp value is measured in milliseconds.

To change the provisioned throughput capacity for a table, use ALTER TABLE.