Explaining what a Lakehouse is!

Подписаться 454 тыс.

Просмотров 37 тыс.

50% 1

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: guyinacu.be/me...
*******************
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: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #GuyInACube

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@esteban-alvino 6 месяцев назад

It's a very nice talk with a lot of energy. That is contagion; it draws a smile from me. Thanks guys

@brianengelbrechtandersen9435 Год назад

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.

@dagg497 5 месяцев назад

Yup we lost the fast data retention of an SQL server and instead have to deal with parquet file conversions..

@lausmaja 10 месяцев назад

Great overview guys. Love it!

@definitelynorandomvideos24 Год назад

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 Год назад

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

@jamieclarke2694 Год назад

Where else? 😅

@spilledgraphics Год назад

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

@WilliamRockseo 11 месяцев назад

Amazing information, Thank You

@matheww9944 Год назад

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

@7anishok390 Год назад

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.

@SetYourBarTo10 Год назад

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.

@Cero_GT Год назад

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

@dagg497 5 месяцев назад

Yeah Fabric is nothing new to me... Data factory and Synapse existed 3years ago.. Sem-structured data storage alternatives as well and Apache Spark and Cosmos DB

@kevinruckstuhl2378 Год назад

More like data swamp

@dagg497 5 месяцев назад

Yeah. I liked Storage Blobs, Data Factory into a Synappse or Azure SQL Database. Lakehouse and parquet is very dependant on a coded scala/python framework and makes every step 10x more confusing and code dependant. We are back to SSIS 2005 and have to code an ETL framework in C+ or instead of working in BI moving into fullstack coding instead..

@MichaelGreen831 6 месяцев назад

I would have loved to hear the problem DW has that DL and DLH solves. I only heard “large” data in contrast to DW historical data.

@dagg497 5 месяцев назад

Personally i don't like DLH all that much due to the slow loading of new data into parquet and the fact you read files instead of SQL tables with history. Who would've known merging 10'000parquet files would be slower than an RDB database?

@rohansrivastwa827 Год назад

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

@Al-vl3tp Год назад

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.