The Azure Data Factory (ADF) team has created an extension for Storage Explorer. This extension allows you to leverage ADF's ability to perform high throughput, server-side transfers from Amazon S3, Azure Blob Storage, or Azure Data Lake Gen2 Storage to Azure Blob Storage or Azure Data Lake Gen2 Storage. Open Storage Explorer. In the left pane, expand the storage account containing the file share you wish to view. Expand the storage account's File Shares. Right-click the file share you wish to view, and - from the context menu - select Open. You can also double-click the file share you wish to view. Train thousands of people, up your skills and get that next awesome job by joining TechSnips and becoming an IT rockstar!
- Windows Azure Storage Explorer Download
- Microsoft Azure Storage Tools Download
- Download Azure Explorer
- Microsoft Azure Storage Explorer Wildcard Search
- Ms Azure Storage Explorer Download
APPLIES TO: SQL API Cassandra API Gremlin API Table API Azure Cosmos DB API for MongoDB
You can use Azure Storage explorer to connect to Azure Cosmos DB. It lets you connect to Azure Cosmos DB accounts hosted on Azure and sovereign clouds from Windows, macOS, or Linux.
Use the same tool to manage your different Azure entities in one place. You can manage Azure Cosmos DB entities, manipulate data, update stored procedures and triggers along with other Azure entities like storage blobs and queues. Azure Storage Explorer supports Cosmos accounts configured for SQL, MongoDB, Graph, and Table APIs.
Note
The Azure Cosmos DB integration with Storage Explorer has been deprecated. Any existing functionality will not be removed for a minimum of one year from this release. You should use the Azure Portal, Azure Portal desktop app or the standalone Azure Cosmos DB Explorer instead. The alternative options contain many new features that aren’t currently supported in Storage Explorer.
Prerequisites
A Cosmos account with a SQL API or an Azure Cosmos DB API for MongoDB. If you don't have an account, you can create one in the Azure portal. See Azure Cosmos DB: Build a SQL API web app with .NET and the Azure portal for more information.
Installation
To install the newest Azure Storage Explorer bits, see Azure Storage Explorer. We support Windows, Linux, and macOS versions.
Connect to an Azure subscription
- After you install Azure Storage Explorer, select the plug-in icon on the left pane.
- Select Add an Azure Account, and then select Sign-in.
- In the Azure Sign-in dialog box, select Sign in, and then enter your Azure credentials.
- Select your subscription from the list, and then select Apply.The Explorer pane updates and shows the accounts in the selected subscription.Your Cosmos DB account is connected to your Azure subscription.
Use a connection string to connect to Azure Cosmos DB
You can use a connection string to connect to an Azure Cosmos DB. This method only supports SQL and Table APIs. Follow these steps to connect with a connection string:
- Find Local and Attached in the left tree, right-click Cosmos DB Accounts, and then select Connect to Cosmos DB.
- In the Connect to Cosmos DB window:
- Select the API from the drop-down menu.
- Paste your connection string in the Connection string box. For how to retrieve the primary connection string, see Get the connection string.
- Enter an Account label, and then select Next to check the summary.
- Select Connect to connect the Azure Cosmos DB account.
Note
If the Azure Storage Explorer shows that the Azure Cosmos DB connection string is in an invalid format, make sure that the connection string has a semicolon (
;
) at the end. An example of a valid Azure Cosmos DB connection string would be: AccountEndpoint=https://accountname.documents.azure.com:443;AccountKey=accountkey;
Use a local emulator to connect to Azure Cosmos DB
Use the following steps to connect to an Azure Cosmos DB with an emulator. This method only supports SQL accounts.
- Install Cosmos DB Emulator, and then open it. For how to install the emulator, seeCosmos DB Emulator.
- Find Local and Attached in the left tree, right-click Cosmos DB Accounts, and then select Connect to Cosmos DB Emulator.
- In the Connect to Cosmos DB window:
- Paste your connection string in the Connection string box. For information on retrieving the primary connection string, see Get the connection string.
- Enter an Account label, and then select Next to check the summary.
- Select Connect to connect the Azure Cosmos DB account.
Azure Cosmos DB resource management
Use the following operations to manage an Azure Cosmos DB account:
- Open the account in the Azure portal.
- Add the resource to the Quick Access list.
- Search and refresh resources.
- Create and delete databases.
- Create and delete collections.
- Create, edit, delete, and filter documents.
- Manage stored procedures, triggers, and user-defined functions.
Quick access tasks
You can right-click a subscription on the Explorer pane to perform many quick action tasks, for example:
- Right-click an Azure Cosmos DB account or database, and then select Open in Portal to manage the resource in the browser on the Azure portal.
- Right-click an Azure Cosmos DB account, database, or collection, and then select Add to Quick Access to add it to the Quick Access menu.
- Select Search from Here to enable keyword search under the selected path.
Database and collection management
Create a database
- Right-click the Azure Cosmos DB account, and then select Create Database.
- Enter the database name, and then press Enter to complete.
Delete a database
- Right-click the database, and then select Delete Database. Reaper 5.965.
- Select Yes in the pop-up window. The database node is deleted, and the Azure Cosmos DB account refreshes automatically.
Create a collection
- Right-click your database, and then select Create Collection.
- In the Create Collection window, enter the requested information, like Collection ID and Storage capacity, and so on. Select OK to finish.
- Select Unlimited so you can specify a partition key, then select OK to finish.NoteIf a partition key is used when you create a collection, once creation is completed, you can't change the partition key value on the collection.
Delete a collection
- Right-click the collection, select Delete Collection, and then select Yes in the pop-up window.The collection node is deleted, and the database refreshes automatically.
Document management
Create and modify documents
Windows Azure Storage Explorer Download
- Open Documents on the left pane, select New Document, edit the contents on the right pane, and then select Save.
- You can also update an existing document, and then select Save. To discard changes, select Discard.
Delete a document
- Select the Delete button to delete the selected document.
Query for documents
- To edit the document filter, enter a SQL query, and then select Apply.
Graph management
Create and modify a vertex
- To create a new vertex, open Graph from the left pane, select New Vertex, edit the contents, and then select OK.
- To modify an existing vertex, select the pen icon on the right pane.
Delete a graph
- To delete a vertex, select the recycle bin icon beside the vertex name.
Filter for graph
- To edit the graph filter, enter a gremlin query, and then select Apply Filter.
Table management
Create and modify a table
- To create a new table:
- On the left pane, open Entities, and then select Add.
- In the Add Entity dialog box, edit the content.
- Select the Add Property button to add a property.
- Select Insert.
- To modify a table, select Edit, modify the content, and then select Update.
Import and export table
- To import, select the Import button, and then choose an existing table.
- To export, select the Export button, and then choose a destination.
Delete entities
- Select the entities, and then select the Delete button.
Query a table
- Select the Query button, input a query condition, and then select the Execute Query button. To close the query pane, select the Close Query button.
Manage stored procedures, triggers, and UDFs
- To create a stored procedure:
- In the left tree, right-click Stored Procedures, and then select Create Stored Procedure.
- Enter a name in the left, enter the stored procedure scripts on the right pane, and then select Create.
- To edit an existing stored procedure, double-click the procedure, make the update, and then select Update to save. You can also select Discard to cancel the change.
- The operations for Triggers and UDF are similar to Stored Procedures.
Troubleshooting
The following are solutions to common issues that arise when you use Azure Cosmos DB in Storage Explorer.
Sign in issues
First, restart your application to see if that fixes the problem. If the problem persists, continue troubleshooting.
Self-signed certificate in certificate chain
There are a few reasons you might be seeing this error, the two most common ones are:
- You're behind a transparent proxy. Someone, like your IT department, intercepts HTTPS traffic, decrypts it, and then encrypts it by using a self-signed certificate.
- You're running software, such as antivirus software. The software injects a self-signed TLS/SSL certificate into the HTTPS messages you receive.
When Storage Explorer finds a self-signed certificate, it doesn't know if the HTTPS message it receives is tampered with. If you have a copy of the self-signed certificate, you can tell Storage Explorer to trust it. If you're unsure of who injected the certificate, then you can follow these steps to try to find out:
- Install OpenSSL:
- Windows: Any of the light versions are OK.
- macOS and Linux: Should be included with your operating system.
- Run OpenSSL:
- Windows: Go to the install directory, then /bin/, then double-click openssl.exe.
- Mac and Linux: Execute openssl from a terminal.
- Execute
s_client -showcerts -connect microsoft.com:443
. - Look for self-signed certificates. If you're unsure, which are self-signed, then look for anywhere that the subject ('s:') and issuer ('i:') are the same.
- If you find any self-signed certificates, copy and paste everything from and including -----BEGIN CERTIFICATE----- to -----END CERTIFICATE----- to a new .CER file for each one.
- Open Storage Explorer, and then go to Edit > SSL Certificates > Import Certificates. Use the file picker to find, select, and then open the .CER files you created.
If you don't find any self-signed certificates, you can send feedback for more help.
Unable to retrieve subscriptions
If you're unable to retrieve your subscriptions after you sign in, try these suggestions:
- Verify that your account has access to the subscriptions. To do this, sign in to the Azure portal.
- Make sure you signed in to the correct environment:
- Custom Environment/Azure Stack
- If you're behind a proxy, make sure that the Storage Explorer proxy is properly configured.
- Remove the account, and then add it again.
- Delete the following files from your home directory (such as: C:UsersContosoUser), and then add the account again:
- .adalcache
- .devaccounts
- .extaccounts
- Press the F12 key to open the developer console. Watch the console for any error messages when you sign in.
Unable to see the authentication page
Microsoft Azure Storage Tools Download
If you're unable to see the authentication page:
- Depending on the speed of your connection, it might take a while for the sign-in page to load. Wait at least one minute before you close the authentication dialog box.
- If you're behind a proxy, make sure that the Storage Explorer proxy is properly configured.
- On the developer tools console (F12), watch the responses to see if you can find any clue for why authentication isn't working.
Can't remove an account
If you're unable to remove an account, or if the reauthenticate link doesn't do anything:
- Delete the following files from your home directory, and then add the account again:
- .adalcache
- .devaccounts
- .extaccounts
- If you want to remove SAS attached Storage resources, delete:
- %AppData%/StorageExplorer folder for Windows
- /Users/<your_name>/Library/Application SUpport/StorageExplorer for macOS
- ~/.config/StorageExplorer for Linux
NoteIf you delete these files, you must reenter all your credentials.
HTTP/HTTPS proxy issue
You can't list Azure Cosmos DB nodes in the left tree when you configure an HTTP/HTTPS proxy in ASE. You can use Azure Cosmos DB data explorer in the Azure portal as a work-around.
'Development' node under 'Local and Attached' node issue
There's no response after you select the Development node under the Local and Attached node in the left tree. The behavior is expected.
Attach an Azure Cosmos DB account in the Local and Attached node error
If you see the following error after you attach an Azure Cosmos DB account in Local and Attached node, then make sure you're using the correct connection string.
Expand Azure Cosmos DB node error
You might see the following error when you try to expand nodes in the left tree.
Try these suggestions:
- Check if the Azure Cosmos DB account is in provision progress. Try again when the account is being created successfully.
- If the account is under the Quick Access or Local and Attached nodes, check if the account is deleted. If so, you need to manually remove the node.
Next steps
- Watch this video to see how to use Azure Cosmos DB in Azure Storage Explorer: Use Azure Cosmos DB in Azure Storage Explorer.
- Learn more about Storage Explorer and connect more services in Get started with Storage Explorer.
Storage Explorer 1.10.0 enables users to upload, download, and copy managed disks, as well as create snapshots. Because of these additional capabilities, you can use Storage Explorer to migrate data from on-premises to Azure, and migrate data across Azure regions.
Prerequisites
To complete this article, you'll need the following:
- An Azure subscription
- One or more Azure managed disks
- The latest version of Azure Storage Explorer
Connect to an Azure subscription
If your Storage Explorer isn't connected to Azure, you will not be able to use it to manage resources. This section goes over connecting it to your Azure account so that you can manage resources using Storage Explorer.
- Launch Azure Storage Explorer and click the plug-in icon on the left.
- Eliese colette goldbach. Select Add an Azure Account, and then click Next.
- In the Azure Sign in dialog box, enter your Azure credentials.
- Select your subscription from the list and then click Apply.
Upload a managed disk from an on-prem VHD
![Storage Storage](/uploads/1/1/8/5/118505742/403854621.jpg)
- On the left pane, expand Disks and select the resource group that you want to upload your disk to.
- Select Upload.
- In Upload VHD specify your source VHD, the name of the disk, the OS type, the region you want to upload the disk to, as well as the account type. In some regions Availability zones are supported, for those regions you can select a zone of your choice.
- Select Create to begin uploading your disk.
- The status of the upload will now display in Activities.
- If the upload has finished and you don't see the disk in the right pane, select Refresh.
Download a managed disk
The following steps explain how to download a managed disk to an on-prem VHD. A disk's state must be Unattached in order to be downloaded, you cannot download an Attached disk.
- On the left pane, if it isn't already expanded, expand Disks and select the resource group that you want to download your disk from.
- On the right pane, select the disk you want to download.
- Select Download and then choose where you would like to save the disk.
- Select Save and your disk will begin downloading. The status of the download will display in Activities.
Copy a managed disk
With Storage Explorer, you can copy a manged disk within or across regions. To copy a disk:
Download Azure Explorer
- From the Disks dropdown on the left, select the resource group that contains the disk you want to copy.
- On the right pane, select the disk you'd like to copy and select Copy.
- On the left pane, select the resource group you'd like to paste the disk in.
- Select Paste on the right pane.
- In the Paste Disk dialog, fill in the values. You can also specify an Availability zone in supported regions.
- Select Paste and your disk will begin copying, the status is displayed in Activities.
Create a snapshot
- From the Disks dropdown on the left, select the resource group that contains the disk you want to snapshot.
- On the right, select the disk you'd like to snapshot and select Create Snapshot.
- In Create Snapshot, specify the name of the snapshot as well as the resource group you want to create it in. Then select Create.
- Once the snapshot has been created, you can select Open in Portal in Activities to view the snapshot in the Azure portal.
Microsoft Azure Storage Explorer Wildcard Search
Next steps
Learn how to Create a VM from a VHD by using the Azure portal.
Ms Azure Storage Explorer Download
Learn how to Attach a managed data disk to a Windows VM by using the Azure portal.