Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2023 01:59 AM
Hi @SigmaTSE ,
In simple words,
- Data Warehouse -> You store data in structured tables to aid your Reporting or BI queries. Better performance for your queries as the data is internally optimized for faster queries.
- Data Lake -> You can store data in any format and it can scale massively. Integrates well with your ETL tool to read and process your data for different use cases. Not so efficient in query performance like your data warehouse.
- Data Lakehouse -> Combination of features of Data Lake + Data Warehouse. Supports massive scale, complex ETL processing as well as milli second query latency. So you get the best of both worlds.
Hope this helps.