System keyspaces in Amazon Keyspaces

local

key, bootstrapped, broadcast_address, cluster_name, cql_version, data_center, gossip_generation, host_id, listen_address, native_protocol_version, partitioner, rack, release_version, rpc_address, schema_version, thrift_version, tokens, truncated_at

Information about the local keyspace.

peers

peer, data_center, host_id, preferred_ip, rack, release_version, rpc_address, schema_version, tokens

Query this table to see the available endpoints. For example, if you're connecting through a public endpoint, you see a list of nine available IP addresses. If you're connecting through a FIPS endpoint, you see a list of three IP addresses. If you're connecting through an Amazon PrivateLink VPC endpoint, you see the list of IP addresses that you have configured. For more information, see Populating system.peers table entries with interface VPC endpoint information.

size_estimates

keyspace_name, table_name, range_start, range_end, mean_partition_size, partitions_count

prepared_statements

prepared_id, logged_keyspace, query_string

This table contains information about saved queries.

keyspaces

keyspace_name, durable_writes, replication

Information about a specific keyspace.

tables

keyspace_name, table_name, bloom_filter_fp_chance, caching, comment, compaction, compression, crc_check_chance, dclocal_read_repair_chance, default_time_to_live, extensions, flags, gc_grace_seconds, id, max_index_interval, memtable_flush_period_in_ms, min_index_interval, read_repair_chance, speculative_retry

Information about a specific table.

columns

keyspace_name, table_name, column_name, clustering_order, column_name_bytes, kind, position, type

Information about a specific column.

keyspaces

keyspace_name, durable_writes, replication

Query this table to find out programmatically if a keyspace has been created. For more information, see Check keyspace creation status in Amazon Keyspaces.

tables

keyspace_name, creation_time, speculative_retry, cdc, gc_grace_seconds, crc_check_chance, min_index_interval, bloom_filter_fp_chance, flags, custom_properties, dclocal_read_repair_chance, table_name, caching, default_time_to_live, read_repair_chance, max_index_interval, extensions, compaction, comment, id, compression, memtable_flush_period_in_ms, status

Query this table to find out the status of a specific table. For more information, see Check table creation status in Amazon Keyspaces.

You can also query this table to list settings that are specific to Amazon Keyspaces and are stored as custom_properties. For example:

tables_history

keyspace_name, table_name, event_time, creation_time, custom_properties, event

Query this table to learn about schema changes for a specific table.

columns

keyspace_name, table_name, column_name, clustering_order, column_name_bytes, kind, position, type

This table is identical to the Cassandra table in the system_schema keyspace.

tags

resource_id, keyspace_name, resource_name, resource_type, tags

Query this table to find out if a keyspace has tags. For more information, see View the tags of a table.

autoscaling

keyspace_name, table_name, provisioned_read_capacity_autoscaling_update, provisioned_write_capacity_autoscaling_update

Query this table to get the auto scaling settings of a provisioned table. Note that these settings won't be available until the table is active. To query this table, you have to specify keyspace_name and table_name in the WHERE clause. For more information, see View your table's Amazon Keyspaces auto scaling configuration.

tables

keyspace_name, table_name, region, status

This table contains information about multi-Region tables—for example, the Amazon Web Services Regions that the table is replicated in and the table's status. You can also query this table to list settings that are specific to Amazon Keyspaces that are stored as custom_properties. For example:

To query this table, you have to specify keyspace_name and table_name in the WHERE clause. For more information, see Create a multi-Region keyspace in Amazon Keyspaces.

autoscaling

keyspace_name, table_name, provisioned_read_capacity_autoscaling_update, provisioned_write_capacity_autoscaling_update, region

Query this table to get the auto scaling settings of a multi-Region provisioned table. Note that these settings won't be available until the table is active. To query this table, you have to specify keyspace_name and table_name in the WHERE clause. For more information, see Update the provisioned capacity and auto scaling settings for a multi-Region table in Amazon Keyspaces.