From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Creating and managing lakehouse shortcuts - Microsoft Fabric Tutorial
From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press
Creating and managing lakehouse shortcuts
Creating and managing Lakehouse Shortcuts. Now with Lakehouse Shortcuts, what we're looking to do is connect to remote data and query it in place without copying that data, and the scenarios in which this is useful is to avoid duplicating data. Instead of copying and moving data from one place to another and then querying it, we can simply shortcut to that data and read it in place. We can also access data that's being changed without having to copy that data and then query for the changes. If the data is being changed at the source we can simply query it with a shortcut. Now it simplifies data architecture again by not copying and moving data unnecessarily. So for example I could have a central lake house that stores all of my source data. I could then shortcuts from other lake houses and can read my centralized source data in my lake house. Now if we've got data in other cloud providers such as AWS and Google, we can shortcut into those other cloud operators and query data in place.…
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Learning objectives35s
-
(Locked)
Choosing between a lakehouse and a warehouse for data storage4m 39s
-
(Locked)
Transforming data using Power Query, PySpark, KQL, and T-SQL6m 37s
-
(Locked)
Creating and managing lakehouse shortcuts5m 34s
-
(Locked)
Creating and managing mirroring5m 46s
-
(Locked)
Using pipelines to ingest data3m 17s
-
(Locked)
Ingesting data by using continuous integration from OneLake2m 19s
-
(Locked)
Designing a dimensional model8m 9s
-
(Locked)
Grouping and aggregating data6m 11s
-
(Locked)
Handling duplicate, missing, and late-arriving data5m 30s
-
(Locked)
Quiz2m 25s
-
(Locked)
-
-
-
-
-
-