Between data lake and data warehouse in enterprise use case
11 Aug 2021| Data Warehouse | Data Lake | |
|---|---|---|
| Data type | Only structured data | AUnstructured or raw |
| Schema | On-Wirte | On-Read |
| User | Business user | Data professionals |
| Data Processing | Extract, Transform, Load | Extract, Load, Transform |
| Application | Business Report/Record | AI/ML, Data science |
| Accessibility | More complicated and costly to make changes | Highly accessible and quick to update |
| Storage | Only required data is kept | Can keep any data |
| Cost | High | Low |