What Is a Data Lake? Definition, Architecture & Examples
Data Lake Definition: How Schema-on-Read Works
What Type of Data is Stored in a Data Lake?
| Data Structure | Characteristics & Formats | Common Real-World Examples |
|---|---|---|
| Structured Data | Highly organized tabular rows and columns with strict data types and relational constraints. | Snapshots and CDC streams from PostgreSQL, MySQL, Oracle, SAP, Salesforce, and financial ledgers. |
| Semi-Structured Data | Data that contains self-describing tags, keys, or nested hierarchies without a fixed relational schema. | JSON API responses, Kafka payloads, Avro files, Parquet columnar data, XML feeds, and web server access logs. |
| Unstructured Data | Data with no predefined conceptual model or formatting, making up over 80% of modern enterprise information. | PDF reports, customer emails, audio recordings, video streams, medical imaging (DICOM), and vector embeddings. |
Data Lake Architecture: The Medallion Multi-Hop Pattern
- Bronze Layer (Raw Ingestion Zone): Exact, immutable replicas of source data stored in native formats (JSON, CSV, Avro, or raw database dumps). Retains full historical lineage for replayability and regulatory audits.
- Silver Layer (Cleansed & Enriched Zone): Filtered, deduplicated, and standardized datasets converted into high-performance columnar formats (Parquet or ORC) wrapped in open table formats like Apache Iceberg or Delta Lake.
- Gold Layer (Curated Analytics Zone): Business-level dimensional aggregates, star schemas, and feature tables optimized for direct consumption by BI dashboards, executive reporting, and predictive AI models.
What is a Data Lake Used For? Key Enterprise Use Cases
- Generative AI & LLM Training: Data lakes act as the foundational training store for LLMs, holding multi-terabyte corpora of unstructured PDFs, chat logs, transcripts, and high-dimensional vector embeddings.
- Change Data Capture (CDC) & Streaming: Continuous ingestion of live operational database events from MySQL, PostgreSQL, and Oracle via Kafka and Debezium, keeping downstream data lakehouse tables synchronized in near real-time.
- Ad-Hoc Interactive SQL Analytics: Using serverless query engines such as Presto, Trino, Google BigQuery Omni, or AWS Athena, analysts can run complex SQL queries directly against raw files in object storage without paying data warehouse ingest penalties.
- Cost-Effective Long-Term Archival: Object storage lifecycle policies automatically transition cold historical datasets into coldline, glacier, or archive tiers, preserving institutional knowledge at pennies per gigabyte.
Is Hadoop a Data Lake or a Data Warehouse?
Data Lake on the Cloud: A Modern Foundation for Your Data - AWS, GCP & Azure

- Decoupled storage and compute architecture design (S3/GCS/ADLS)
- Open table format integration (Apache Iceberg, Delta Lake, or Apache Hudi)
- Enterprise Data Catalog setup (AWS Glue, GCP Dataplex / Data Catalog, Azure Purview)
- Cloud cost governance and automated lifecycle archival policies
- Granular IAM role-based access control (RBAC) and column-level masking
- Automated data quality assertions and schema evolution management
- DataOps telemetry, pipeline health alerting, and monitoring
Frequently Asked Questions About Data Lakes
What is a Data Lake?
A Data Lake is a centralized storage repository that holds vast amounts of raw data in its native format until needed. It stores structured (relational databases), semi-structured (JSON, Parquet, XML), and unstructured data (text, logs, media) at massive scale, applying schema-on-read during query execution rather than during ingestion.
What is the definition of a data lake?
By definition, a data lake is an enterprise data storage architecture that ingests all forms of raw organizational data into low-cost object storage without requiring upfront schema transformations. Consumers can then transform and query subsets of that data on-demand for machine learning, BI reporting, and predictive analytics.
What type of data is stored in a data lake?
A data lake stores three primary categories of data: (1) Structured data from relational databases (PostgreSQL, MySQL, Oracle); (2) Semi-structured data such as JSON API payloads, web server logs, CSV, and Parquet files; and (3) Unstructured data including audio, video, images, PDFs, sensor streams, and social media feeds.
What is a data lake used for?
A data lake is used for machine learning and AI training, business intelligence reporting, ad-hoc exploratory analytics, streaming IoT telemetry ingestion, and long-term cost-effective data archival. It provides a single source of truth across siloed business departments.
Is Hadoop considered a data lake or a data warehouse?
Hadoop (specifically HDFS) was the pioneer of the original on-premises data lake architecture. Hadoop is not a data warehouse. Modern architectures have largely replaced on-premises Hadoop HDFS with cloud object storage (Amazon S3, Google Cloud Storage, Azure Blob Storage) coupled with modern open table formats like Apache Iceberg.
What is the difference between a data lake and a data warehouse?
A data lake stores raw data in any format (structured, semi-structured, unstructured) and applies schema on read, making it flexible for data exploration, ML, and streaming. A data warehouse stores processed, structured data with a fixed schema applied on write, optimised for BI reporting and SQL analytics. Read our detailed comparison in Data Lake vs Data Warehouse.
What open table formats are used in a modern data lake?
The three industry-standard open table formats are Apache Iceberg (hidden partitioning, time travel, broad engine support), Delta Lake (ACID transactions and Spark ecosystem integration), and Apache Hudi (fast CDC upserts with Copy-on-Write and Merge-on-Read table types).