top of page
Writer's picture@mrpaulandrew

Browsing Microsoft Fabric OneLake via Azure Storage Explorer

Browsing Microsoft Fabric OneLake storage via the Windows App, similar to the OneDrive app is nice, but to help understand what else is happening underneath, looking at the files through Azure Storage Explorer can be even better.


Fabric and OneLake Icons

Like all Microsoft cloud storage, OneLake uses the following sub domains and prefixes to access both Blob and Data Lake (equivalent) file systems.


https://onelake.blob.fabric.microsoft.com/

https://onelake.dfs.fabric.microsoft.com/


Then these base URLs you can be expanded where you can expect to find the following hierarchy of content. With no real surprises if your familiar with how a Delta Lake table looks in storage.


 

Base URL

{Workspace GUID}

{Lakehouse GUID}

Tables

{Table Name}

_delta_log

{File Number}.json

{File Number}.checkpoint.parquet

part-00000-{File GUID}.snappy.parquet

Files

TableMaintenance

 

To access your OneLake using Azure Storage Explorer first get the GUID for a given Microsoft Fabric workspace. This can be found if you look at your address bar in your preferred browser for your Microsoft Fabric tenant. Example below.


How to image 1

Then, open Azure Storage Explorer and connect to a new resource. Select the ADLS Gen2 Container or Directory connector.


How to image 2

Choose OAuth to authenticate and sign in via the browser prompts to access your tenant. These steps are implied and not included in the screenshots.


Next, select your user details from the list, if you have multiple account and enter the connection information as follows. Enter a suitable name for the new resource connection. Then add your URL, this is the base URL (as above), plus the Fabric workspace GUID copying from your browser address bar.

For example: https://onelake.dfs.fabric.microsoft.com/12345-12345-12345-123456-12345


How to image 3

Finish the connection wizard and return to your main storage explorer panels. Now with a new connection to your chosen Fabric workspace and OneLake storage.


How to image 4

Happy browsing.

 

Many thanks for reading.


128 views0 comments

Comments


Be the first to know

Subscribe to our blog to get updates on new posts.

Thanks for subscribing!

TRANSFORM YOUR BUSINESS

bottom of page