Install Microsoft Azure Storage Explorer

 admin



  1. Azure Storage Explorer Installer Download
  2. Microsoft Azure Storage Explorer App
  3. Install Microsoft Azure Storage Explorer Windows 10
  4. Microsoft Azure Storage Explorer Silent Install
  5. Azure Storage Manager Explorer Download

Easily manage the contents of your storage account with Azure Storage Explorer. Upload, download, and manage blobs, files, queues, tables, and Cosmos DB entities. Gain easy access to manage your virtual machine disks. Work with either Azure Resource Manager or classic storage accounts, plus manage and configure cross-origin resource sharing (CORS) rules. microsoft/AzureStorageExplorer. In this article, you'll learn how to use Storage Explorer to work with blob containers and blobs. To complete the steps in this article, you'll need the following: Download and install Storage Explorer; Connect to an Azure storage account or service; Create a blob container.

-->

Overview

Azure Blob Storage is a service for storing large amounts of unstructured data, such as text or binary data, that can be accessed from anywhere in the world via HTTP or HTTPS.You can use Blob storage to expose data publicly to the world, or to store application data privately. In this article, you'll learn how to use Storage Explorerto work with blob containers and blobs.

Prerequisites

To complete the steps in this article, you'll need the following:

Create a blob container

All blobs must reside in a blob container, which is simply a logical grouping of blobs. An account can contain an unlimited number of containers, and each container can store an unlimited number of blobs.

The following steps illustrate how to create a blob container within Storage Explorer.

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account within which you wish to create the blob container.

  3. Right-click Blob Containers, and - from the context menu - select Create Blob Container.

  4. A text box will appear below the Blob Containers folder. Enter the name for your blob container. See Create a container for information on rules and restrictions on naming blob containers.

  5. Press Enter when done to create the blob container, or Esc to cancel. Once the blob container has been successfully created, it will be displayed under the Blob Containers folder for the selected storage account.

View a blob container's contents

Blob containers contain blobs and folders (that can also contain blobs).

The following steps illustrate how to view the contents of a blob container within Storage Explorer:

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container you wish to view.

  3. Expand the storage account's Blob Containers.

  4. Right-click the blob container you wish to view, and - from the context menu - select Open Blob Container Editor.You can also double-click the blob container you wish to view.

  5. The main pane will display the blob container's contents.

Delete a blob container

Blob containers can be easily created and deleted as needed. (To see how to delete individual blobs,refer to the section, Managing blobs in a blob container.)

Azure Storage Explorer Installer Download

The following steps illustrate how to delete a blob container within Storage Explorer:

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container you wish to view.

  3. Expand the storage account's Blob Containers.

  4. Right-click the blob container you wish to delete, and - from the context menu - select Delete.You can also press Delete to delete the currently selected blob container.

  5. Select Yes to the confirmation dialog.

Copy a blob container

Storage Explorer enables you to copy a blob container to the clipboard, and then paste that blob container into another storage account. (To see how to copy individual blobs,refer to the section, Managing blobs in a blob container.)

The following steps illustrate how to copy a blob container from one storage account to another.

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container you wish to copy.

  3. Expand the storage account's Blob Containers.

  4. Right-click the blob container you wish to copy, and - from the context menu - select Copy Blob Container.

  5. Right-click the desired 'target' storage account into which you want to paste the blob container, and - from the context menu - select Paste Blob Container.

Get the SAS for a blob container

A shared access signature (SAS) provides delegated access to resources in your storage account.This means that you can grant a client limited permissions to objects in your storage account for a specified period of time and with a specified set of permissions, without having toshare your account access keys.

The following steps illustrate how to create a SAS for a blob container:

Microsoft Azure Storage Explorer App

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container for which you wish to get a SAS.

  3. Expand the storage account's Blob Containers.

  4. Right-click the desired blob container, and - from the context menu - select Get Shared Access Signature.

  5. In the Shared Access Signature dialog, specify the policy, start and expiration dates, time zone, and access levels you want for the resource.

  6. When you're finished specifying the SAS options, select Create.

  7. A second Shared Access Signature dialog will then display that lists the blob container along with the URL and QueryStrings you can use to access the storage resource.Select Copy next to the URL you wish to copy to the clipboard.

  8. When done, select Close.

Manage Access Policies for a blob container

The following steps illustrate how to manage (add and remove) access policies for a blob container:

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container whose access policies you wish to manage.

  3. Expand the storage account's Blob Containers.

  4. Select the desired blob container, and - from the context menu - select Manage Access Policies.

  5. The Access Policies dialog will list any access policies already created for the selected blob container.

  6. Follow these steps depending on the access policy management task:

    • Add a new access policy - Select Add. Once generated, the Access Policies dialog will display the newly added access policy (with default settings).
    • Edit an access policy - Make any desired edits, and select Save.
    • Remove an access policy - Select Remove next to the access policy you wish to remove.
Storage

Set the Public Access Level for a blob container

By default, every blob container is set to 'No public access'.

The following steps illustrate how to specify a public access level for a blob container.

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container whose access policies you wish to manage.

  3. Expand the storage account's Blob Containers.

  4. Select the desired blob container, and - from the context menu - select Set Public Access Level.

  5. In the Set Container Public Access Level dialog, specify the desired access level.

  6. Select Apply.

Managing blobs in a blob container

Once you've created a blob container, you can upload a blob to that blob container, download a blob to your local computer, open a blob on your local computer,and much more.

The following steps illustrate how to manage the blobs (and folders) within a blob container.

  1. Open Storage Explorer.

  2. In the left pane, expand the storage account containing the blob container you wish to manage.

  3. Expand the storage account's Blob Containers.

  4. Double-click the blob container you wish to view.

  5. The main pane will display the blob container's contents.

  6. The main pane will display the blob container's contents.

  7. Follow these steps depending on the task you wish to perform:

    • Upload files to a blob container

      1. On the main pane's toolbar, select Upload, and then Upload Files from the drop-down menu.

      2. In the Upload files dialog, select the ellipsis (…) button on the right side of the Files text box to select the file(s) you wish to upload.

      3. Specify the type of Blob type. See Create a container for more information.

      4. Optionally, specify a target folder into which the selected file(s) will be uploaded. If the target folder doesn’t exist, it will be created.

      5. Select Upload.

    • Upload a folder to a blob container

      1. On the main pane's toolbar, select Upload, and then Upload Folder from the drop-down menu.

      2. In the Upload folder dialog, select the ellipsis (…) button on the right side of the Folder text box to select the folder whose contents you wish to upload.

      3. Specify the type of Blob type. See Create a container for more information.

      4. Optionally, specify a target folder into which the selected folder's contents will be uploaded. If the target folder doesn’t exist, it will be created.

      5. Select Upload.

    • Download a blob to your local computer

      1. Select the blob you wish to download.
      2. On the main pane's toolbar, select Download.
      3. In the Specify where to save the downloaded blob dialog, specify the location where you want the blob downloaded, and the name you wish to give it.
      4. Select Save.

    • Open a blob on your local computer

      1. Select the blob you wish to open.
      2. On the main pane's toolbar, select Open.
      3. The blob will be downloaded and opened using the application associated with the blob's underlying file type.

    • Copy a blob to the clipboard

      1. Select the blob you wish to copy.
      2. On the main pane's toolbar, select Copy.
      3. In the left pane, navigate to another blob container, and double-click it to view it in the main pane.
      4. On the main pane's toolbar, select Paste to create a copy of the blob.

    • Delete a blob

      1. Select the blob you wish to delete.
      2. On the main pane's toolbar, select Delete.
      3. Select Yes to the confirmation dialog.

Next steps

Microsoft
  • View the latest Storage Explorer release notes and videos.
  • Learn how to create applications using Azure blobs, tables, queues, and files.
-->

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

  1. After you install Azure Storage Explorer, select the plug-in icon on the left pane.

  2. Select Add an Azure Account, and then select Sign-in.

  3. In the Azure Sign-in dialog box, select Sign in, and then enter your Azure credentials.

  4. 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:

  1. Find Local and Attached in the left tree, right-click Cosmos DB Accounts, and then select Connect to Cosmos DB.

  2. In the Connect to Cosmos DB window:

    1. Select the API from the drop-down menu.

    2. Paste your connection string in the Connection string box. For how to retrieve the primary connection string, see Get the connection string.

    3. Enter an Account label, and then select Next to check the summary.

    4. 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.

  1. Install Cosmos DB Emulator, and then open it. For how to install the emulator, seeCosmos DB Emulator.

  2. Find Local and Attached in the left tree, right-click Cosmos DB Accounts, and then select Connect to Cosmos DB Emulator.

  3. In the Connect to Cosmos DB window:

    1. Paste your connection string in the Connection string box. For information on retrieving the primary connection string, see Get the connection string.

    2. Enter an Account label, and then select Next to check the summary.

    3. 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

  1. Right-click the Azure Cosmos DB account, and then select Create Database.

  2. Enter the database name, and then press Enter to complete.

Delete a database

  1. Right-click the database, and then select Delete Database.

  2. Select Yes in the pop-up window. The database node is deleted, and the Azure Cosmos DB account refreshes automatically.

Create a collection

  1. Right-click your database, and then select Create Collection.

  2. In the Create Collection window, enter the requested information, like Collection ID and Storage capacity, and so on. Select OK to finish.

  3. Select Unlimited so you can specify a partition key, then select OK to finish.

    Note

    If 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

Storage

Create and modify documents

  • 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.

Download microsoft azure explorerInstall Microsoft Azure Storage Explorer

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:

    1. On the left pane, open Entities, and then select Add.

    2. In the Add Entity dialog box, edit the content.

    3. Select the Add Property button to add a property.

    4. 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:

    1. In the left tree, right-click Stored Procedures, and then select Create Stored Procedure.

    2. 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:

  1. Install OpenSSL:

    • Windows: Any of the light versions are OK.
    • macOS and Linux: Should be included with your operating system.

  2. Run OpenSSL:

    • Windows: Go to the install directory, then /bin/, then double-click openssl.exe.
    • Mac and Linux: Execute openssl from a terminal.

  3. Execute s_client -showcerts -connect microsoft.com:443.

  4. 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.

  5. 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.

  6. 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

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

    Note

    If you delete these files, you must reenter all your credentials.

Install Microsoft Azure Storage Explorer Windows 10

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

Microsoft Azure Storage Explorer Silent Install

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.

Azure Storage Manager Explorer Download

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.