Forum Discussion
Post ProdigyComparison between data warehouse, data lake and data lakehouse
Hi pmscorca ,
Okay, that's more at a glance.
Feature
Data Warehouse
Data Lake
Data Lakehouse
Data Structure
Highly structured
Structured and unstructured
Combines both
Use Case
Business intelligence and reporting
Big data analytics, machine learning
BI, reporting, and advanced analytics
Data Type
Primarily structured data
Raw and semi-structured data
Handles all data types
Query Performance
Fast querying
Slower querying
Advanced querying capabilities
Cost
Generally higher
More cost-effective for large volumes
Balances cost efficiency with performance
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi pmscorca ,
Thanks for the reply from frithjof_v , your reply worked like a charm.
This table summarizes the differences between the data warehouse vs. data lake vs. data lakehouse.
A data warehouse is a good choice for companies seeking a mature, structured data solution that focuses on business intelligence and data analytics use cases. However, data lakes are suitable for organizations seeking a flexible, low-cost, big-data solution to drive machine learning and data science workloads on unstructured data.
Suppose the data warehouse and data lake approaches aren’t meeting your company’s data demands, or you’re looking for ways to implement both advanced analytics and machine learning workloads on your data. In that case, a data lakehouse is a reasonable choice.
More information can be found in this document:
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
pmscorcaHi, thanks for you reply.
I'm preparing a training course and so I need to search a synthetic feature comparison at a glance between data warehouse, data lake and data lakehouse, not too articles to read.
Other features to match in a synthetic manner? Thanks
Hi pmscorca ,
Okay, that's more at a glance.
Feature
Data Warehouse
Data Lake
Data Lakehouse
Data Structure
Highly structured
Structured and unstructured
Combines both
Use Case
Business intelligence and reporting
Big data analytics, machine learning
BI, reporting, and advanced analytics
Data Type
Primarily structured data
Raw and semi-structured data
Handles all data types
Query Performance
Fast querying
Slower querying
Advanced querying capabilities
Cost
Generally higher
More cost-effective for large volumes
Balances cost efficiency with performance
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!