Azure storage explorer

In my last article, we have discussed Azure storage types. Here, we will discuss about Azure storage explorer. Apart from this, we will also discuss on the below topics

Azure Storage Explorer
  • Benefits of Azure storage explorer
  • Is Azure storage explorer free?
  • How to Set up the Azure storage Explorer?
  • Azure storage explorer download
  • How to use Azure Storage Explorer
  • Add a resource via Azure AD
  • Use a connection string
  • Azure Storage connection strings
  • Use a shared access signature (SAS) URI
  • Use a storage account name and key
  • Attach to a local emulator
  • Connect to an Azure Cosmos DB using a connection string
  • Connect to Azure Data Lake Store by URI
  • Azure storage explorer command line
  • How fast is AzCopy?
  • How to install AzCopy for Azure storage
  • Azure storage explorer alternative

Azure storage explorer

Azure storage explorer is an excellent tool from Microsoft that will definitely improve your development experience with Azure storage.

This is an application that helps you to connect Azure storage account with any device. It supports different operating systems like Windows, Linux, Mac OS, etc.

A Free tool from Microsoft to manage your Azure resources.

Benefits of Azure storage explorer

  • Easy to use with very simple and user-friendly UI.
  • You can connect easily and can access multiple storage accounts.
  • We can easily deal with the storage management that increase the productivity.
  • You can wok with connecting to the cloud as well as offline.
  • Multiple platform support like Windows, Linux,macOS, etc.

Is Azure storage explorer free?

Yes, it is a free tool from Microsoft that supports multiple operating systems like Windows, Linux, Mac OS, etc. This is a tool that helps you to connect Azure storage account with any device.

How to Set up the Azure storage Explorer?

To Set up the Azure storage explorer, we need to download and install the Azure storage explorer. To do that, follow the below section.

Azure storage explorer download

You need to down load the Azure storage explorer from the Microsoft official site.

Select the operating system and then click on the Download now button.

You will get a StorageExplorer.exe file, run the exe.

azure storage explorer download

Click on the Finish button to complete the installation

How to configure the Azure storage Explorer

Now to access the Azure storage explorer, from the start menu, you can search for Azure storage explorer and then click on that to open it.

How to access the Azure storage Explorer?

Click on the Add an account link.

Set up the Azure storage Explorer

On the Connect to Azure Storage window, You will find multiple options like below

  • Add a resource via Azure Active Directory (Azure AD)
  • Use a connection string
  • Use a shared access signature(SAS) URI
  • Use a storage account name and key
  • Attach to a local emulator

You can select any of the above options to log in or else you can directly click on the Next button without selecting any of the options it will ask you to enter your Azure credentials.

azure storage explorer online

After clicking on the Next button, It will prompt you to enter your Microsoft Azure credentials. Enter your credentials to log in.

How to download Azure storage explorer

Once you will log in, Choose the subscription for which you want to work for the storage account and then click on the Apply button to save the changes.

how to configure the Azure storage Explorer

Now you can able to see all the storage accounts and other details under the same subscription.

Configure Azure storage Explorer

Blob Container

You can do the following operations using Azure Storage Explorer

  • Create Blob Container
  • Configure CORS Settings
  • Configure Soft Delete Policy
  • Query, Import, Export, Add Edit, Delete etc
How to create blob container using Azure Storage Explorer

Blob Storage

You can do the following operations using Azure Storage Explorer

  • Copy Blobs and folders
  • List Blob Containers
  • Uploading and Downloading Blobs
  • Delete Blobs
Why to Set up the Azure storage Explorer

Table Storage

You can do the following operations using Azure Storage Explorer

  • Create Table
  • Import, Export functionality.
  • Query, Add, Edit, Delete entities.
How to create a table storage in Azure storage Explorer

Queue Storage

You can do the following operations using Azure Storage Explorer

  • Create a queue
  • View message, Add message, Dequeue message, Requeue message, Clear Queue, etc
how to create a queue storage using Azure storage explorer

File Storage

You can do the following operations using Azure Storage Explorer

  • Create file share
  • Upload,download,copy, paste, etc
  • Create and Delete Directory
How to create file storage using Azure stroage explorer

How to use Azure Storage Explorer

Here to understand how exactly it works, we will see how to create a table storage and do all the operations using Azure explorer.

Table storage consists of a number of entities. Entities are objects with properties. Each entity is related to partition key, row key, and timestamp.

Partition key

Partition key is an unique identifier and known as the first part of the primary key used for the partition in a table.

Row key

Row key is called as the second part of the primary key. Every entity has one partition key and one-row key which is used to create the clustered index that helps for the first index for the storage.

Now to create a table you can follow the below steps. Select the table node and then right-click on that and click on the create table link else from the Actions section click on the Create table link.

What is a partition key in Azure storage

Now provide a name for the table storage

What is a row key in Azure storage

Now if you will see for the Demo1 table storage there is no data for the partition key and row key and there is no data currently.

In order to add the partition key and row key click on the Add button on the menu and provide the partition key as Employee and row key as IT.

Add a new property called Name by clicking the Add property button and provide the value as Information Technology.

Then click on the insert button.

How to use Azure Storage Explorer

Now you can see one record has been added to the table

Using Azure Storage Explorer

Add few more records to the table

How to filter the records in a  table using Azure storage explorer

Now you can add a filter condition to filter the record

How to filter the records in a  table using Azure storage explorer

Add a resource via Azure AD

Click on the Open connect Dialog button from the left side

Add a resource via Azure AD using Azure storage explorer

Select the option Add a resource via Azure Active Directory (Azure AD) and then click on the Next button.

how to add a resource via Azure AD

Select an Azure account and tenant. Account must have access to the Storage resource you want to attach to. Select Next.

how to add a resource via Azure Active Directory

Choose the resource type, provide the Container URL and provide the Connection display name. Click on the Next button.

Now on the next step, review the Connection Summary to make sure all the information is correct. If in case any information is incorrect, you can edit it again by clicking on the back button. If all the information provided is correct then you can click on the Connect button.

Once the connection is successfully added you can see it on Local & Attached –> Storage Accounts –> (Attached Containers) –> Blob Containers.

Use a connection string

Click on the Open connect Dialog button from the left side

Add a resource using connection string

Azure Storage connection strings

Select the Use a connection string option and then click on the Next button

Connect to a resource using a connection string

Provide a display name for the connection and enter your connection string. Select Next button.

Now review the Connection Summary and verify if all the information provided is correct, if not you can click on the Back button and do the changes else all the information is correct click on the Connect button.

Now once the connection established successfully, you can see the resource under Local & Attached –> Storage Accounts.

Use a shared access signature (SAS) URI

Click on the Open connect Dialog button from the left side

Add a resource via shared access signature (SAS) URI

Select the Use a shared access signature (SAS) URI option and then click on the Next button.

Add a resource via shared access signature (SAS) URI

Provide a display name and enter your shared access signature URI. service endpoint for the resource type should be autofill. Click on the Next button.

Now in the Connection Summary page, verify if all the information provided is correct, if not you can click on the Back button and do the changes else all the information is correct click on the Connect button.

You can see the resource under Local & Attached –> Storage Accounts –> (Attached Containers) > Service node .

Use a storage account name and key

Click on the Open connect Dialog button from the left side

Add a resource via storage account name and key

Select Use a storage account name and key and then click on the Next button.

Add a resource via storage account name and key

Provide the display name, Account name, Access key and choose a Storage Domain and then click on the Next button.

Now in the Connection Summary page, verify if all the information provided is correct, if not you can click on the Back button and do the changes else all the information is correct click on the Connect button.

You can see the resource under Local & Attached –> Storage Accounts.

Attach to a local emulator

Azure Storage Explorer supports two types of official Storage emulators

  • Azure Storage Emulator: This is available only for the Windows operating system.
  • Azurite: This is available for Windows, macOS, or Linux operating systems.

If your emulator is not running on the default port then follow the below steps

You can start your emulator. Enter the command AzureStorageEmulator.exe status.

Click on the Open connect Dialog button from the left side

Add a resource via Attach to a local emulator

Select the Attach to a local emulator option and then click on the Next button.

Add a resource via Attach to a local emulator

Provide a display name and enter the ports your emulator is listening. Attach to a Local Emulator suggests the default port values for most emulators. you can enter the port to use. Then, select Next.

Now in the Connection Summary page, verify if all the information provided is correct, if not you can click on the Back button and do the changes else all the information is correct click on the Connect button.

You can see the resource under Local & Attached –> Storage Accounts.

Connect to an Azure Cosmos DB using a connection string

We can use a connection string to connect an Azure Cosmos DB.

Under Local & Attached, right-click Cosmos DB Accounts(Preview), and select Connect to Cosmos DB.

One more way is under Actions, click on Connect to Cosmos DB.

Connect to an Azure Cosmos DB using a connection string

Select API, enter your Connection String data, and then select Next button to connect to the Azure Cosmos DB.

Connect to Azure Data Lake Store by URI

Under Local & Attached, right-click Data Lake Storage Gen1(Preview), and select Connect to Data Lake Storage Gen1.

One more way is under Actions, click on Connect to Data Lake Storage Gen1.

How to connect to Azure Data Lake Store by URI

On the Connect to Data Lake Store window, provide the ADL URI, and then click on the OK button to connect to the Data Lake Storage.

Azure storage explorer command line

In this, AzCopy is the command-line utility that helps you for the in and out data transfer from the Azure storage explorer and to copy blobs or files to or from a storage account.

The performance of file/data transfer is really great here in case of AzCopy utility.

How fast is AzCopy?

There are great improvements in uploading files with AzCopy.

Below table shows the improvement level as per Microsoft.

Storage ExplorerStorage Explorer w/AzCopy% of Improvements
10K 100KB files1 hour 36 minutes59 seconds98.9 percent
100 100MB5 minutes 12 seconds1 minute 35 seconds69.5 percent
1 10GB file3 minutes 41 seconds1 minute 40 seconds54.7 percent

How to install AzCopy for Azure storage

AzCopy is available for different operating system like Windows, Linux and MacOS.

You can install the AzCopy from the Microsoft site.

Click on the Links based on your operating system where you want to install the AzCopy. Here we will see the installation for Windows operating system.

How to install AzCopy for Azure storage

Once you will click on the Windows 64-bit (zip) link,

you will get the zip file downloaded. You can extract the file in any of your physical drive and copy that complete path and keep it in a notepad.

Get started with AzCopy

Now inside the extracted folder, if you try to run the application file by double-clicking it, it will show that This is a command-line tool you need to open the cmd.exe to run it.

How to Get started with AzCopy

Now open the command prompt, go to the path where you have extracted the folder (You can copy the path from the note pad you have copied earlier).

cd C:\Users\Bijay\Desktop\azcopy_windows_amd64_10.4.3

From that path, type the command AzCopy and hit Enter. You can able to see all the command with details.

Install AzCopy for Azure storage

Azure storage explorer alternative

There are some alternative options available in Market if you do not want to go with this.

Below are the list of alternatives

  • AWS Storage Gateway
  • VMware vSAN
  • Datrium
  • StorPool
  • Zadara Storage
  • NetApp Cloud Volumes ONTAP
  • Google Hybrid Cloud
  • NooBaa
  • Igneous DataProtect
  • Compellent

You may like following Azure tutorials:

Conclusion

In this tutorial, we learned the below things:

  • Azure storage explorer
  • Benefits of Azure storage explorer
  • Is Azure storage explorer free?
  • How to Set up the Azure storage Explorer?
  • Azure storage explorer download
  • How to use this
  • Add a resource via Azure AD
  • Use a connection string
  • Azure Storage connection strings
  • Use a shared access signature (SAS) URI
  • Use a storage account name and key
  • Attach to a local emulator
  • Connect to an Azure Cosmos DB using a connection string
  • Connect to Azure Data Lake Store by URI
  • Azure storage explorer command line
  • How fast is AzCopy?
  • How to install AzCopy for Azure storage
  • Azure storage explorer alternative

Leave a Comment