Storage Explorer can connect to a storage account using the storage account's name and key. You can find your account keys in the Azure portal. Open your storage account page and select Settings Access keys. In the Select Resource panel of the Connect to Azure Storage dialog, select Storage account. We are sending our logs to Azure Table Storage. I am trying to query those logs but finding it hard to do via Azure Storage Explorer. I can't imagine why there is not a 'contains' option to filter the RowKey column (where our actual log data is contained.).
- An Azure Data Explorer cluster is a pair of engine and data management clusters which uses several Azure resources such as Azure Linux VM’s and Storage. The applicable VMs, Azure Storage, Azure Networking and Azure Load balancer costs are billed directly to the customer subscription. Azure Data Explorer clusters are billed on a per minute basis.
- Optimize your Azure storage management. Upload, download, and manage Azure blobs, files, queues, and tables, as well as Azure Cosmos DB and Azure Data Lake Storage entities. Easily access virtual machine disks, and work with either Azure Resource Manager or classic storage accounts. Manage and configure cross-origin resource sharing rules.
- Freeware Azure Blob Storage explorer allows tracking, analyzing and debugging your usage of storage. It also comes with full support for Microsoft Azure Storage Analytics. CloudBerry Explorer PRO makes Azure Cloud Storage management even easier, more secure and efficient.
Overview
Microsoft Azure Storage Explorer is a standalone app that makes it easy to work with Azure Storage data on Windows, macOS, and Linux.
In this article, you'll learn several ways of connecting to and managing your Azure storage accounts.
Prerequisites
The following versions of Windows support Storage Explorer:
- Windows 10 (recommended)
- Windows 8
- Windows 7
For all versions of Windows, Storage Explorer requires .NET Framework 4.7.2 at a minimum.
The following versions of macOS support Storage Explorer:
- macOS 10.12 Sierra and later versions
Storage Explorer is available in the Snap Store for most common distributions of Linux. We recommend Snap Store for this installation. The Storage Explorer snap installs all of its dependencies and updates when new versions are published to the Snap Store.
For supported distributions, see the snapd installation page.
Storage Explorer requires the use of a password manager. You might have to connect to a password manager manually. You can connect Storage Explorer to your system's password manager by running the following command:
Storage Explorer is also available as a .tar.gz download. If you use the .tar.gz, you must install dependencies manually. The following distributions of Linux support .tar.gz installation:
- Ubuntu 20.04 x64
- Ubuntu 18.04 x64
- Ubuntu 16.04 x64
The .tar.gz installation might work on other distributions, but only these listed ones are officially supported.
For more help installing Storage Explorer on Linux, see Linux dependencies in the Azure Storage Explorer troubleshooting guide.
Download and install
To download and install Storage Explorer, see Azure Storage Explorer.
Connect to a storage account or service
Storage Explorer provides several ways to connect to Azure resources:
Sign in to Azure
Note
To fully access resources after you sign in, Storage Explorer requires both management (Azure Resource Manager) and data layer permissions. This means that you need Azure Active Directory (Azure AD) permissions to access your storage account, the containers in the account, and the data in the containers. If you have permissions only at the data layer, consider choosing the Sign in using Azure Active Directory (Azure AD) option when attaching to a resource. For more information about the specific permissions Storage Explorer requires, see the Azure Storage Explorer troubleshooting guide.
In Storage Explorer, select View > Account Management or select the Manage Accounts button.
ACCOUNT MANAGEMENT now displays all the Azure accounts you're signed in to. To connect to another account, select Add an account....
The Connect to Azure Storage dialog opens. In the Select Resource panel, select Subscription.
In the Select Azure Environment panel, select an Azure environment to sign in to. You can sign in to global Azure, a national cloud or an Azure Stack instance. Then select Next.
Tip
For more information about Azure Stack, see Connect Storage Explorer to an Azure Stack subscription or storage account.
Storage Explorer will open a webpage for you to sign in.
After you successfully sign in with an Azure account, the account and the Azure subscriptions associated with that account appear under ACCOUNT MANAGEMENT. Select the Azure subscriptions that you want to work with, and then select Apply.
EXPLORER displays the storage accounts associated with the selected Azure subscriptions.
Attach to an individual resource
Storage Explorer lets you connect to individual resources, such as an Azure Data Lake Storage Gen2 container, using various authentication methods. Some authentication methods are only supported for certain resource types.
| Resource type | Azure AD | Account Name and Key | Shared Access Signature (SAS) | Public (anonymous) |
|---|---|---|---|---|
| Storage accounts | Yes | Yes | Yes (connection string or URL) | No |
| Blob containers | Yes | No | Yes (URL) | Yes |
| Gen2 containers | Yes | No | Yes (URL) | Yes |
| Gen2 directories | Yes | No | Yes (URL) | Yes |
| File shares | No | No | Yes (URL) | No |
| Queues | Yes | No | Yes (URL) | No |
| Tables | No | No | Yes (URL) | No |
Storage Explorer can also connect to a local storage emulator using the emulator's configured ports.
To connect to an individual resource, select the Connect button in the left-hand toolbar. Then follow the instructions for the resource type you want to connect to.
When a connection to a storage account is successfully added, a new tree node will appear under Local & Attached > Storage Accounts.
For other resource types, a new node is added under Local & Attached > Storage Accounts > (Attached Containers). The node will appear under a group node matching its type. For example, a new connection to an Azure Data Lake Storage Gen2 container will appear under Blob Containers.
If Storage Explorer couldn't add your connection, or if you can't access your data after successfully adding the connection, see the Azure Storage Explorer troubleshooting guide.
The following sections describe the different authentication methods you can use to connect to individual resources.
Azure AD
Storage Explorer can use your Azure account to connect to the following resource types:
- Blob containers
- Azure Data Lake Storage Gen2 containers
- Azure Data Lake Storage Gen2 directories
- Queues
Azure AD is the preferred option if you have data layer access to your resource but no management layer access.
- Sign in to at least one Azure account using the steps described above.
- In the Select Resource panel of the Connect to Azure Storage dialog, select Blob container, ADLS Gen2 container, or Queue.
- Select Sign in using Azure Active Directory (Azure AD) and select Next.
- Select an Azure account and tenant. The account and tenant must have access to the Storage resource you want to attach to. Select Next.
- Enter a display name for your connection and the URL of the resource. Select Next.
- Review your connection information in the Summary panel. If the connection information is correct, select Connect.
Account name and key
Storage Explorer can connect to a storage account using the storage account's name and key.
You can find your account keys in the Azure portal. Open your storage account page and select Settings > Access keys.
- In the Select Resource panel of the Connect to Azure Storage dialog, select Storage account.
- Select Account name and key and select Next.
- Enter a display name for your connection, the name of the account, and one of the account keys. Select the appropriate Azure environment. Select Next.
- Review your connection information in the Summary panel. If the connection information is correct, select Connect.
Shared access signature (SAS) connection string
Storage Explorer can connect to a storage account using a connection string with a Shared Access Signature (SAS). A SAS connection string looks like this:
- In the Select Resource panel of the Connect to Azure Storage dialog, select Storage account.
- Select Shared access signature (SAS) and select Next.
- Enter a display name for your connection and the SAS connection string for the storage account. Select Next.
- Review your connection information in the Summary panel. If the connection information is correct, select Connect.
Shared access signature (SAS) URL
Storage Explorer can connect to the following resource types using a SAS URI:
- Blob container
- Azure Data Lake Storage Gen2 container or directory
- File share
- Queue
- Table
A SAS URI looks like this:
- In the Select Resource panel of the Connect to Azure Storage dialog, select the resource you want to connect to.
- Select Shared access signature (SAS) and select Next.
- Enter a display name for your connection and the SAS URI for the resource. Select Next.
- Review your connection information in the Summary panel. If the connection information is correct, select Connect.
Local storage emulator
Storage Explorer can connect to an Azure Storage emulator. Currently, there are two supported emulators:
- Azure Storage Emulator (Windows only)
- Azurite (Windows, macOS, or Linux)
If your emulator is listening on the default ports, you can use the Local & Attached > Storage Accounts > Emulator - Default Ports node to access your emulator.
If you want to use a different name for your connection, or if your emulator isn't running on the default ports:
Start your emulator.
Important
Storage Explorer doesn't automatically start your emulator. You must start it manually.
In the Select Resource panel of the Connect to Azure Storage dialog, select Local storage emulator.
Enter a display name for your connection and the port number for each emulated service you want to use. If you don't want to use to a service, leave the corresponding port blank. Select Next.
Review your connection information in the Summary panel. If the connection information is correct, select Connect.
Connect to Azure Cosmos DB
Storage Explorer also supports connecting to Azure Cosmos DB resources.
Connect to an Azure Cosmos DB account by using a connection string
Instead of managing Azure Cosmos DB accounts through an Azure subscription, you can connect to Azure Cosmos DB by using a connection string. To connect, follow these steps:
Under EXPLORER, expand Local & Attached, right-click Cosmos DB Accounts, and select Connect to Azure Cosmos DB.
Select the Azure Cosmos DB API, enter your Connection String data, and then select OK to connect the Azure Cosmos DB account. For information about how to retrieve the connection string, see Manage an Azure Cosmos account.
Connect to Azure Data Lake Store by URI
You can access a resource that's not in your subscription. You need someone who has access to that resource to give you the resource URI. After you sign in, connect to Data Lake Store by using the URI. To connect, follow these steps:
Under EXPLORER, expand Local & Attached.
Right-click Data Lake Storage Gen1, and select Connect to Data Lake Storage Gen1.
Enter the URI, and then select OK. Your Data Lake Store appears under Data Lake Storage.
This example uses Data Lake Storage Gen1. Azure Data Lake Storage Gen2 is now available. For more information, see What is Azure Data Lake Storage Gen1.
Generate a shared access signature in Storage Explorer
Account level shared access signature
Right-click the storage account you want share, and then select Get Shared Access Signature.
In Shared Access Signature, specify the time frame and permissions you want for the account, and then select Create.
Copy either the Connection string or the raw Query string to your clipboard.
Service level shared access signature
You can get a shared access signature at the service level. For more information, see Get the SAS for a blob container.
Search for storage accounts
To find a storage resource, you can search in the EXPLORER pane.
As you enter text in the search box, Storage Explorer displays all resources that match the search value you've entered up to that point. This example shows a search for endpoints:
Note
To speed up your search, use Account Management to deselect any subscriptions that don't contain the item you're searching for. You can also right-click a node and select Search From Here to start searching from a specific node.
Next steps
-->Creating a table is an important step in the process of data ingestion and query in Azure Data Explorer. After you have created a cluster and database in Azure Data Explorer, you can create a table. The following article shows how to create a table and schema mapping quickly and easily using the Azure Data Explorer Web UI.
Prerequisites
Azure Table Explorer
- If you don't have an Azure subscription, create a free Azure account before you begin.
- Create an Azure Data Explorer cluster and database.
- Sign in to the Azure Data Explorer Web UI and add a connection to your cluster.
Create a table
In the left menu of the Web UI, right-click on your database name and select Create table.
The Create table window opens with the Source tab selected.
- The Database field is auto-populated with your database. You may select a different database from the drop-down menu.
- In Table name, enter a name for your table.
Tip
Table names can be up to 1024 characters including alphanumeric, hyphens, and underscores. Special characters aren't supported.
Select source type
In Source type, select the data source you'll use to create your table mapping. Choose from the following options: From blob, From file, or From container.
If you're using a container:
- Enter the storage url of your blob, and optionally enter the sample size.
- Filter your files using the File Filters.
- Select a file that will be used in the next step to define the schema.
If you're using a local file:
- Select Browse to locate the file, or drag the file into the field.
If you're using a blob:
- In the Link to storage field, add the SAS URL of the container and optionally enter the sample size.
Select Edit Schema to continue to the Schema tab.
Edit Schema
In the Schema tab, your data format and compression are automatically identified in the left-hand pane. If incorrectly identified, use the Data format dropdown menu to select the correct format.
Table Storage Explorer Azure
If your data format is JSON, you must also select JSON levels, from 1 to 10. The levels determine the table column data division.
If your data format is CSV, select the check box Includes column names to ignore the heading row of the file.
- In Mapping, enter a name for this table's schema mapping.
Tip
Table names can include alphanumeric characters and underscores. Spaces, special characters, and hyphens aren't supported.
- Select Create.
Create table completed window
In the Create table completed window, both steps will be marked with green check marks when table creation finishes successfully.
Select View command to open the editor for each step.
- In the editor, you can view and copy the automatic commands generated from your inputs.
In the tiles below the Create table progress, explore Quick queries or Tools:
Azure Table Explorer App
Quick queries includes links to the Web UI with example queries.
Tools includes links to Undo the running the relevant .drop commands.
Note
Azure Storage Tables
You might lose data when you use .drop commands.
The drop commands in this workflow will only revert the changes that were made by the create table process (new table and schema mapping).
Next steps