Create your FIRST Lakehouse in Microsoft Fabric

You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake!

What is a lakehouse in Microsoft Fabric?

Create a lakehouse in Microsoft Fabric

Ted Vilutis


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#MicrosoftFabric #Lakehouse #GuyInACube

[faraazali]

Thank you for this detailed tutorial! Keep up the great work. Quick questions, what video editing tool do you all use to overlay the blue boxes and commentary?

[ianfahlman-morgan]

Love this! So inspiring and clear on how this new element works!

Also, how can I get my hands on a "guy in a cube" sticker for my laptop? ❤

[prasadparab]

Awesome... Thanks for explaining in details 👏🙏

[BardstaleGoldens]

So…this may be a stupid question, but will we be able to create a shortcut to an azure sql table instead of having to pipeline copy the data and keep it updated?

[rafalg]

Beatiful. I am waiting when otgnization will decide to implement MS Fabric.

[ericduquesne]

Lakehouse Links are an interesting feature to use, it looks like a database link for Cloud endpoints.

[bladerunnerisback]

Thanks for sharing! Is there a performance impact when using shortcuts? My understanding is data imported into the lakehouse as delta tables but with shortcuts the data remains in it's original format. Maybe a video about it?

[desert_edition_na]

This dude is awesome. Data by day, BJJ by night.

[SureshGuddanti]

Thank you for this, I have a question though when we use Shortcut say to Amazon S3, and start using that data in Fabric for analysis, is that data not leaving s3 at all even to process In memory on the fabric end? I was comparing this to connecting an external HDD to a PC and accessing data, I was under impression that data gets in to memory of PC, if this is the same concept are we looking at egress charges ? Finally how will shortcuts work with high volume of data?

[andikadwinugraha]

Q: I'm new in this field, and I'm curious can I use this tool to store historical data as part of migrating data and build my own data storage? Or if there are any tools that suitable instead of using SharePoint Folder? Thanks to GIAC for sharing great video!

[alessandrofrancisco]

Hi Guys, whe i create a pipeline, is possibel to "copy" using an data gateway like i do in powerbi?

[Seveq]

How about changing schemas in my source data, like, when I make a shortcut to some data somewhere in the OneLake and have a sophisticated setup of joins and merges, and then one of the data owners decides to change the schema of their data. Will this immediately break my setup? How can we prevent this from happening? How does Fabric help to mitigate this?

[tanushriaditya]

what is the difference between One LAke and LAke house?

[hpqyuio]

How can we create Linked Server for Fabric lakehouse in ssms.

[hilldiver]

One thing that's not so clear to me is how the OneLake "one copy" concept works with the lakehouse medallion architecture. As an example I have a landing lakehouse where I use a dataflow gen2 to load Contoso DB from a local SQL server with no transformations, this is the bronze raw data layer. If I then want to do some transformations, e.g. merging product category and subcategory into product table to help with star schema, how do I do this? Shortcuts don't help as far as I can see, as they're just a virtualisation of what exists. So I'd need to create a pipeline copy job with the transformations and land in a new silver lakehouse, but then I've copied the data, which goes against the onelake concept? Am I missing something fundamental here?

[NayankaGothane]

How does Synapse differ from Fabric? Why didn't the team use the Synapse platform and add features if there were new ones?

[TedSeeber]

Didn't we already have a hundred different ways to store structured and unstructured data? What does lakehouse give us that say, NTFS didn't?