Microsoft Fabric: Local OneLake Tools
Ғылым және технология
Sometimes you need to be able to interact with your cloud data locally - maybe it's to troubleshoot/diagnose an issue, or just to do some analysis using your favourite local tools. Ideally you'd be able to browse your cloud data locally and avoid always having to download new copies of your files just to do this.
Fortunately, there are a couple of tools that allow you to do just this with your OneLake data - namely the OneLake File Explorer and the trusty old Azure Storage Explorer. In this video we take a look at the two tools, and discuss some of the caveats you should be aware of when using them.
Microsoft Fabric End to End Demo - Part 5 - Navigating OneLake Data Locally
00:00 Intro
00:13 What is the OneLake File Explorer?
01:16 Recap: OneLake Lakehouse view
02:12 OneLake File Explorer Online Docs
02:33 Admin installation settings
03:12 Downloading OneLake File Explorer
03:30 Demo: Navigating OneLake File Explorer
04:24 Adding, deleting and syncing files
06:09 Gotcha 1 - "System" file access in OneLake File Explorer
07:20 Gotcha 2 - possible egress costs
09:55 What is Azure Storage Explorer?
10:32 Demo: Connecting to OneLake in Azure Storage Explorer
12:32 Navigating OneLake data in Azure Storage Explorer
13:57 Roundup & Outro
Useful links:
📖 OneLake File Explorer docs: learn.microsoft.com/en-us/fab...
📖 Browsing OneLake with Azure Storage Explorer docs: learn.microsoft.com/en-us/fab...
Series contents:
📺 Part 1 - Lakehouse & Medallion Architecture - • Microsoft Fabric: Lake...
📺 Part 2 - Planning and Architecting a Data Project - • Microsoft Fabric: Insp...
📺 Part 3 - Ingest Data - • Microsoft Fabric: Inge...
📺 Part 4 - Creating a shortcut to ADLS Gen2 in Fabric - • Microsoft Fabric: Crea...
📺 Part 5 - Navigating OneLake data locally - • Microsoft Fabric: Loca...
📺 Part 6 - Role of the Silver layer in the Medallion Architecture - • Microsoft Fabric: Role...
📺 Part 7 - Processing Bronze to Silver - • Microsoft Fabric: Proc...
If you want to learn more about Fabric, take a look at some of our other content:
📺 Part 8 - Good Notebook Development Practices - • Microsoft Fabric: Good...
🤖 [Course] Microsoft Fabric: from Descriptive to Predictive Analytics: • Microsoft Fabric: Mach...
👉 Perspectives on #MicrosoftFabric: endjin.com/what-we-think/talk...
👉 A Tour Around #MicrosoftFabric: endjin.com/what-we-think/talk...
👉 Introduction to #MicrosoftFabric: endjin.com/blog/2023/05/intro...
and find all the rest of our content here: endjin.com/blog/2023/05/micro...
#MicrosoftFabric #onelake #lakehouse #datalake #dataengineering #data #ai #analytics #medallion #bronze #silver #gold
Пікірлер: 3
Thank you for watching, if you enjoyed this episode, please hit like 👍subscribe, and turn notifications on 🔔it helps us more than you know. 🙏
Hello Ed, I am an ETL tester. Project recently shifted to fabric Lake House. I can not run SP_help to validate metadata in it through SSMS.can you help?
@endjin
9 ай бұрын
The T-SQL surface area in Microsoft Fabric is not as wide as in other SQL Server products. There's an article here that goes through some more limitations: learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area Unfortunately it's not very detailed, so you're going to have to do a bit of trial and error to try to find a way of getting the information you need. But remember, all data is stored as Delta under the covers, so you may be able to also use Spark Delta Lake metadata queries to get similar information.