Explaining what a Lakehouse is!

Explaining what a Lakehouse is!

Guy in a Cube

1 год назад

35,434 Просмотров

You've probably heard the term lakehouse with various services like Azure Synapse Analytics. But what actually is a lakehouse? And why is it different from a data warehouse?

📢 Become a member: https://guyinacu.be/membership

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

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

🎓 Guy in a Cube courses: https://guyinacu.be/courses

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

-- http://twitter.com/guyinacube
-- http://twitter.com/awsaxton
-- http://twitter.com/patrickdba
-- http://www.facebook.com/guyinacube
-- https://www.instagram.com/guyinacube/
-- https://guyinacube.com

***Gear***
🛠 Check out my Tools page - https://guyinacube.com/tools/

#PowerBI #GuyInACube

Тэги:

#azure_synapse #azure_synapse_analytics #azure_synapse_data_lakehouse #azure_synapse_lake_database_vs_sql_database #azure_synapse_lakehouse #big_data #big_data_analytics #data_lake #data_lake_vs_data_warehouse #data_warehouse #lake_house #lakehouse #lakehouse_azure_synapse
Ссылки и html тэги не поддерживаются


Комментарии:

@lausmaja
@lausmaja - 12.11.2023 23:25

Great overview guys. Love it!

Ответить
@WilliamRockseo
@WilliamRockseo - 23.10.2023 19:54

Amazing information, Thank You

Ответить
@surfh3r0
@surfh3r0 - 25.09.2023 08:47

interesting! thanks!

Ответить
@martiruda
@martiruda - 30.05.2023 02:07

funny this is called data constelation, someone added lakehouse just to sell training courses I bet.

Ответить
@minathanh7072
@minathanh7072 - 22.01.2023 06:51

Great video, thank you!!!

Ответить
@7anishok390
@7anishok390 - 22.12.2022 18:06

Hi Please help me. I have created an external table in the synapse lake database, Now I like to load the records from the external table into the dedicated SQL pool table. Please advice on the procedure.

Ответить
@Al-vl3tp
@Al-vl3tp - 22.12.2022 16:30

Yes, we are building a data lake house with the structured data transformed pointing to redshift and all of the unstructured data pointing to the S3 buckets. But the data scientists can't query the data in Athena and point the data to Power BI for analytics and data visualizations.

Ответить
@brianengelbrechtandersen9435
@brianengelbrechtandersen9435 - 30.11.2022 00:53

We have been using Data Lakehouse mostly with sql serverless for around a year now and it works very well for our customers.. We have to think differently when designing the ETL/ELT but basically we still end up with a snowflake schema and great performance. However, it requires a tool like Power Bi premium for caching data bc of the rather slow and unpredictiable latency from the serverless.

Ответить
@oscarparadajr
@oscarparadajr - 04.11.2022 21:00

We are looking to implement a DW, DL, and/or DLH where I work so I am looking EXTREMELY FORWARD to those videos. Thank you!!!

Ответить
@mwaltercpa
@mwaltercpa - 04.11.2022 02:47

Chris Wagner is pointing us toward Synapse Analytics, I got a book and would love to also watch GIAC videos!

Ответить
@rohansrivastwa827
@rohansrivastwa827 - 03.11.2022 10:04

Can your audio be more clear with less base and noise?

Ответить
@shilpapathi
@shilpapathi - 02.11.2022 23:45

Great content and engaging, worth every minute.

Ответить
@SetYourBarTo10
@SetYourBarTo10 - 02.11.2022 16:42

I wonder if the increase in remote work impacted naming conventions? …data lakes…data streams…lake house…I am started to feel like someone has a better view while they work.

Ответить
@matheww9944
@matheww9944 - 02.11.2022 16:29

Was that you Patrick on the "Power BI Update - October 2022" ? :)

Ответить
@simon2093
@simon2093 - 02.11.2022 16:04

Yep, now building out a company wide lakehouse - early days at the moment. But this thing is nuts fantastic. Especially loving delta tables.

Ответить
@spilledgraphics
@spilledgraphics - 02.11.2022 14:38

where does the concept of datamarts (not Power BI datamarts) fit into this combo of data lakehouse?

Ответить
@brianxyz
@brianxyz - 02.11.2022 10:37

What is a Databrick? TIA

Ответить
@juliangimbel1583
@juliangimbel1583 - 02.11.2022 09:39

Great video, but using the Azure machine learning icon for the data lake is confusing for me 😅

Ответить
@kevinruckstuhl2378
@kevinruckstuhl2378 - 01.11.2022 22:44

More like data swamp

Ответить
@Milhouse77BS
@Milhouse77BS - 01.11.2022 22:00

But... what about...a...: "Lake Database" :)

Ответить
@1yyymmmddd
@1yyymmmddd - 01.11.2022 21:49

Data warehouses are dead, aren't they?

Ответить
@Cero_GT
@Cero_GT - 01.11.2022 20:51

Neat. We’ve been taking this approach for a couple years now but didn’t give it a fancy name.

Ответить
@kurrysamir
@kurrysamir - 01.11.2022 18:32

Great content as always! Awaiting the slowed down version with some hands!!

Ответить
@definitelynorandomvideos24
@definitelynorandomvideos24 - 01.11.2022 18:25

Great Video, at my company we are currently trying to identify which architecture is the best to unify the many data silos we have. Looks like I can show a possible solution ;)

Ответить
@johnnyw5627
@johnnyw5627 - 01.11.2022 18:12

When the Data Warehouse and the Data Lake went out for a few beers... was it in Belgium?

Ответить
@premcst
@premcst - 01.11.2022 18:09

Waiting for the slow downed version Patrick !!

Ответить