Work with data using Azure Cosmos DB Explorer
APPLIES TO: SQL API Cassandra API Gremlin API Table API Azure Cosmos DB API for MongoDB
Azure Cosmos DB Explorer is a standalone web-based interface that allows you to view and manage the data stored in Azure Cosmos DB. Azure Cosmos DB Explorer is equivalent to the existing Data Explorer tab that is available in Azure portal when you create an Azure Cosmos DB account. The key advantages of Azure Cosmos DB Explorer over the existing Data explorer are:
You have a full screen real-estate to view your data, run queries, stored procedures, triggers, and view their results.
You can provide temporary or permanent read or read-write access to your database account and its collections to other users who do not have access to Azure portal or subscription.
You can share the query results with other users who do not have access to Azure portal or subscription.
Access Azure Cosmos DB Explorer
Sign in to Azure portal.
From All resources, find and navigate to your Azure Cosmos DB account, select Keys, and copy the Primary Connection String.
Go to https://cosmos.azure.com/, paste the connection string and select Connect. By using the connection string, you can access the Azure Cosmos DB Explorer without any time limits.
If you want to provide other users temporary access to your Azure Cosmos DB account, you can do so by using the read-write and read access URLs.
Open the Data Explorer blade, select Open Full Screen. From the pop-up dialog, you can view two access URLs – Read-Write and Read. These URLs allow you to share your Azure Cosmos DB account temporarily with other users. Access to the account expires in 24 hours after which you can reconnect by using a new access URL or the connection string.
Read-Write – When you share the Read-Write URL with other users, they can view and modify the databases, collections, queries, and other resources associated with that specific account.
Read - When you share the read-only URL with other users, they can view the databases, collections, queries, and other resources associated with that specific account. For example, if you want to share results of a query with your teammates who don't have access to Azure portal or your Azure Cosmos DB account, you can provide them with this URL.
Choose the type of access you'd like to open the account with and click Open. After you open the explorer, the experience is same as you had with the Data Explorer tab in Azure portal.
Currently the Open Full Screen experience that allows you to share temporary read-write or read access is not yet supported for Azure Cosmos DB Gremlin and Table API accounts. You can still view your Gremlin and Table API accounts by passing the connection string to Azure Cosmos DB Explorer.
Currently, viewing documents that contain a UUID is not supported in Data Explorer. This does not affect loading collections, only viewing individual documents or queries that include these documents. To view and manage these documents, users should continue to use the tool that was originally used to create these documents.
Customers receiving HTTP-401 errors may be due to insufficient Azure RBAC permissions for the customer's Azure account, particularly if the account has a custom role. Any custom roles must have
Microsoft.DocumentDB/databaseAccounts/listKeys/* action to use Data Explorer if signing in using their Azure Active Directory credentials.
Now that you have learned how to get started with Azure Cosmos DB Explorer to manage your data, next you can: