KNOW the difference between Data Base // Data Warehouse // Data Lake (Easy Explanation👌)

I have watched or read many explanation about the differences among these 3 terms, but so far this video is the simpliest yet cleariest and easiest to understand. Thanks a lot!!!

This was awesome

The best explanation that I heard. Thanks!

I have always struggled to understand what a datawarehouse is but this video made it so simple to understand thank you

Big query is a data warehouse not data lake, yes it can be used as a datalake but primarily it's a data warehouse.

amazing thanks

Entertaining and easy to understand, thanks Chandoo!

Chandoo…you have a divine gift for explaining things so clearly. The drawings help so much too. I wish I had found your channel sooner.

Thanks, really helped me to understand the concepts 🙏🙏

Without any flattery- the BEST explanation of this topic I ever encountered on youtube!

Very well explained. Thanks

YOU ARE THE BEST THANKZ SIR

Thank you for the information:)

Your video is the only one that made this clear to me.. thank you teacher!

Hi Chandoo,
thanks for your explanation!
I am looking for literature, which shows more detailed processes and roles for Data Warehouse and Data Lakes, highlighting the challenges for each role in the data management.
Example: What are the challenges for a Data Engineer, Analyst, Scientist, … in a Data Warehouse or in a Data Lake.
Can you suggest any kind of literature source for this kind of information?

Great explanation 👌

Really helped sir! Thank you so much for the clarification! It definitely came in handy!

Thank you for explaining this so simple!

Very clear! good explaination!

There was not ppt , just sweet and crisp explanation of the topic using a notebook. 👌🏽 Loved it.

I could be all wrong, please correct me if I am. BigQuery is a DW solution, not a DL solution. DL for BigQuery could be any storage layer like GCS. Any thoughts ?

Great example, very well explained! Thank you for making this video

This is awsome explanation. Thanks!

Just the way I like it, Barney style! Amazing job!!!

Nicely explained, many thanks!

What about Lakehouse architectures?

Awesome video!

Thanks for the clearly explaining!

Hi, your video is very clear to understand the basics… but still I have question, please clarify.
1) why can't ETL take the source table and target table in the databases itself to create reporting or historical data table. Why we need to load into another database and call it as Data warehouse? Is there any significant difference like performance or something? Please explain this part… you explained "Why we are using each type", but I want you to cover why can't we use one instead of other. Eg., why cant we use create historical table in databases itself, why we need data warehouse separately. What is the special thing to go to DW instead of DB… also "why DL? And why can't DW?"

Good explanation…, but do we have actually have a standardization for these terms… Everyone uses data-warehouse / data-lakes interchangeably..

Amazing info following frm long recently got promotted as manager in analytics. Thanks aton

Excellent explanation… Can't resist myself to appreciate your efforts publicly…

Well explained 👏👏

This was the best explanatory video that I came across!!

AWS, Azure are not Datalakes, they are Cloud Platforms, S3, Blob storage are examples of datalake on these platforms. On GCP example is Cloud Storage and NOT Big Query, BQ is not a datalake

Spot on!

You are awesome man! Keep helping