Azure Cosmosdb

Azure Cosmos DB

Manage Cosmos DB databases and query data.

List accounts

az cosmosdb list --query '[].{Name:name,ResourceGroup:resourceGroup,Kind:kind,Location:locations[0].locationName}' -o table

List databases

az cosmosdb sql database list --account-name my-cosmos --resource-group my-rg --query '[].{Name:name}' -o table

List containers

az cosmosdb sql container list --account-name my-cosmos --resource-group my-rg --database-name my-db --query '[].{Name:name,PartitionKey:resource.partitionKey.paths[0]}' -o table

Query documents

az cosmosdb sql container query --account-name my-cosmos --resource-group my-rg \
  --database-name my-db --container-name my-container \
  --query-text "SELECT TOP 10 * FROM c WHERE c.status = 'active'" | jq '.[] | {id, status}'

Get connection strings

az cosmosdb keys list --name my-cosmos --resource-group my-rg --type connection-strings | jq '.connectionStrings[0].connectionString'

Get throughput

az cosmosdb sql container throughput show --account-name my-cosmos --resource-group my-rg \
  --database-name my-db --container-name my-container | jq '{throughput: .resource.throughput, autoscaleMax: .resource.autoscaleSettings.maxThroughput}'

Update throughput

az cosmosdb sql container throughput update --account-name my-cosmos --resource-group my-rg \
  --database-name my-db --container-name my-container --throughput 1000

Notes

• Cosmos DB supports SQL, MongoDB, Cassandra, Gremlin, and Table APIs.
• Use az cosmosdb sql for SQL API; replace sql with the API type for others.
• Confirm before modifying throughput (cost implications).