View the tags of a table - Amazon Keyspaces (for Apache Cassandra)

View the tags of a table

The following examples show how to the tags of a table in Amazon Keyspaces using the console, CQL, or the AWS CLI.

Console
View the tags of a table using the console
  1. Sign in to the AWS Management Console, and open the Amazon Keyspaces console at https://console.aws.amazon.com/keyspaces/home.

  2. In the navigation pane, choose Tables.

  3. Choose a table from the list and choose the Tags tab.

Cassandra Query Language (CQL)
View the tags of a table using CQL

To read the tags attached to a table, use the following CQL statement.

SELECT * FROM system_schema_mcs.tags WHERE valid_where_clause;

The WHERE clause is required, and must use one of the following formats:

  • keyspace_name = 'mykeyspace' AND resource_name = 'mytable'

  • resource_id = arn

  • The following query returns the tags of the specified table.

    SELECT * FROM system_schema_mcs.tags WHERE keyspace_name = 'mykeyspace' AND resource_name = 'mytable';

    The output of that query looks like the following.

    resource_id | keyspace_name | resource_name | resource_type | tags ----------------------------------------------------------------------------+---------------+---------------+---------------+------ arn:aws:cassandra:us-east-1:123456789:/keyspace/mykeyspace/table/mytable | mykeyspace | mytable | table | {'key1': 'val1', 'key2': 'val2'}
CLI
View the tags of a table using the AWS CLI
  • This example shows how to list the tags of the specified resource.

    aws keyspaces list-tags-for-resource --resource-arn 'arn:aws:cassandra:us-east-1:111222333444:/keyspace/myKeyspace/table/myTable'

    The output of the last command looks like this.

    { "tags": [ { "key": "key1", "value": "val1" }, { "key": "key2", "value": "val2" }, { "key": "key3", "value": "val3" }, { "key": "key4", "value": "val4" } ] }