View the tags of a table - Amazon Keyspaces (for Apache Cassandra)
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 Amazon CLI.

Console
View the tags of a table using the console
  1. Sign in to the Amazon Web Services Management Console, and open the Amazon Keyspaces console at https://console.amazonaws.cn/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 Amazon 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" } ] }