Cosmos Table

Overview

Azure Cosmos DB provides the Table API (Table storage), designed to support cloud-scale applications that can contain billions of entities ("rows" in relational database terminology), or datasets that must support high transaction volumes. Once a Cosmos Table is associated with a Business Application, it can be managed from Turbo360.

Business value

Managing Cosmos Table entities from Turbo360 removes the need to switch to a separate database tool, letting you query, update, and clean up table data directly during operational tasks.

How it works

• Once associated with a Business Application, the table's entities become directly queryable and manageable from Turbo360.

Permissions

Access to Cosmos Table actions is controlled through RBAC when adding a role to a Business Application.

Operations

Turbo360 lets you query and manage Cosmos Table entities directly from the resource, without switching to a separate database tool.

Managing entities

• Query entities — retrieve table entities by executing a query. Use this when you need to inspect data without opening a separate database client.
• Update entity — edit an entity returned from a query. Use this when a single record needs correction.
• Delete entity — remove an entity returned from a query. Use this when a single record needs to be removed.

Bulk operations

• Bulk delete — delete multiple entities returned from a query in a single action. Use this when cleaning up a large batch of stale or invalid records rather than deleting entities one at a time.

Resource dashboard

The Cosmos Table dashboard surfaces request volume and capacity signals so you can spot throttling or unexpected usage spikes without leaving Turbo360.

You can add, remove, or reconfigure widgets to focus on the metrics most relevant to your support scenario.

Metrics

The Metrics tab lets you chart any Azure metric for your Cosmos Table directly in Turbo360, without switching to the Azure portal. Use it to track RU consumption per table operation, request throughput, and throttled request rates — useful for identifying whether read/write patterns from specific application workloads are exhausting provisioned capacity.

Use the following controls to build your chart:

Click Apply to render the chart.

Monitoring

Cosmos Table supports metric and query monitoring rules, configured under Cosmos Table -> Monitoring.

Metric monitoring

Tracks resource metrics against a configured threshold. Use this when you need to be alerted if RU consumption or another metric exceeds expected bounds.

1. Switch to the Rules tab.
2. Select the necessary monitoring metrics and configure the threshold values.
3. Click Save.

The threshold values can be provided with any metric name; the rule is violated when the configured threshold value is met.

Query monitoring

Tracks the result of a saved or custom query against a threshold. Use this when a specific query result, such as a record count, needs to trigger an alert.

1. Switch to the Queries tab.
2. Click Add.
3. Enter a name for the query rule.
4. Enter the desired query, or select one from saved queries using Open from saved queries.
5. Click Validate to validate the query.
6. Click Save.

Troubleshooting

1. Query monitoring rule does not trigger
   Cause: The query was not validated before saving.
   Fix: Reopen the rule, click Validate, and save again.
2. Entity update or delete not reflected
   Cause: The query results were not refreshed after the change.
   Fix: Re-run the query to fetch the latest entity state.
3. Bulk delete only removes some entities
   Cause: The query results changed between selection and deletion.
   Fix: Re-run the query and retry the bulk delete on the refreshed result set.
4. Dashboard widgets show no data
   Cause: The table was recently associated and has not completed its first monitoring cycle.
   Fix: Wait for the next monitoring cycle, then refresh the dashboard.

Related articles

• Cosmos SQL Container
• Cosmos SQL Database
• Rules configuration