Browse and edit Cosmos DB documents
Browse databases and containers, read documents as a table, tree or JSON, and edit with review and an _etag check.
The sidebar lists the databases in your account and the containers in each one. It shows the partition key of every container, and you can filter the list by name. If a list is cut at the item limit, Tablyne says so.
Opening a container shows the Items tab. Nothing is read until you enter the partition key and run the query. You can also read one document by its id and partition key. Results appear as a table, a tree or JSON. In the table view, the search bar finds a value across the loaded documents.
To change a document, edit a cell or open the JSON editor. The JSON editor is strict, and _rid, _etag and _ts stay with the server. You can add a new document, delete one, or move one. Moving changes the id or the partition key. It creates the new document and then deletes the old one. That is not atomic, and Tablyne warns that both documents will exist if the second step fails.
Nothing is sent until you open the review. The review lists each operation with its If-Match value. If a document changed since you read it, the server answers 412, that operation is marked as a conflict, and nothing is written for it. Cosmos DB has no transaction here, so a batch stops at the first error. Each operation shows its own result: written, conflict, error, not sent or unknown.
The Container menu creates and deletes containers and opens the settings. Settings cover the default TTL, throughput, the indexing policy and unique keys. Each change is reviewed first. Creating a container shows an estimated monthly cost, because throughput is billed hourly.
If the connection is read-only, creating, editing and deleting are turned off, and the app says why. Copying a container to another connection is not available.