Amazon KeyspacesSRE & Consulting Services

# Query ReadThrottleEvents, WriteThrottleEvents, and ConsumedWCUs
aws cloudwatch get-metric-data \
  --metric-data-queries '[
    {"Id":"w_throttle","MetricStat":{"Metric":{"Namespace":"AWS/Cassandra","MetricName":"WriteThrottleEvents","Dimensions":[{"Name":"KeyspaceName","Value":"prod_data"},{"Name":"TableName","Value":"orders"}]},"Period":60,"Stat":"Sum"}},
    {"Id":"r_throttle","MetricStat":{"Metric":{"Namespace":"AWS/Cassandra","MetricName":"ReadThrottleEvents","Dimensions":[{"Name":"KeyspaceName","Value":"prod_data"},{"Name":"TableName","Value":"orders"}]},"Period":60,"Stat":"Sum"}},
    {"Id":"consumed_wcu","MetricStat":{"Metric":{"Namespace":"AWS/Cassandra","MetricName":"ConsumedWriteCapacityUnits","Dimensions":[{"Name":"KeyspaceName","Value":"prod_data"},{"Name":"TableName","Value":"orders"}]},"Period":60,"Stat":"Sum"}}
  ]' \
  --start-time $(date -u -v-15M +%Y-%m-%dT%H:%M:%SZ) \
  --end-time $(date -u +%Y-%m-%dT%H:%M:%SZ)

# Audit partition clustering and custom properties
cqlsh cassandra.us-east-1.amazonaws.com 9142 \
  -u "$KEYSPACES_USER" -p "$KEYSPACES_PASS" --ssl \
  --execute="DESCRIBE TABLE prod_data.orders;"

# Query system schema table metadata without table locking
cqlsh cassandra.us-east-1.amazonaws.com 9142 \
  -u "$KEYSPACES_USER" -p "$KEYSPACES_PASS" --ssl \
  --execute="SELECT keyspace_name, table_name, custom_properties FROM system_schema_keyspaces.tables WHERE keyspace_name='prod_data';"