CDL Data Fundamentals: Data Lakes and Warehouses, First- to Third-Party Data, the Data Supply Chain, and Governance

The data concept questions new to CDL Domain 2: databases vs. data warehouses vs. data lakes, first-, second-, and third-party data, the six stages of the data supply chain from genesis to activation, data governance, and the openness that prevents silos and lock-in.

In the August 2026 revision of the Cloud Digital Leader exam guide, Domain 2 (about 18%) opens with "the intrinsic role that data plays in an organization's digital transformation." It includes several concept questions: telling databases, data warehouses, and data lakes apart; first-, second-, and third-party data; the data supply chain; data governance; and the openness needed to avoid data silos and vendor lock-in. These are questions you solve by understanding the concepts first, not by memorizing product names.

This post starts with why data is valuable, then covers the three kinds of data stores, the types of data, the data supply chain, data governance, and openness and interoperability. The basics of structured, semi-structured, and unstructured data and storage services such as Cloud Storage and BigQuery are covered first in Data Transformation.

---

 

Why Data Is Valuable

Data is an organization's compass. It tells you where you are, which way you are heading, and where you should go. The exam guide gives four reasons data is valuable.

| Value | Meaning | Example | |------|------|------| | Real-time business insights | See what is happening now and respond immediately | Spotting unusual payment activity instantly to stop fraud | | Identifying trends | Find changes and patterns over time | Using seasonal sales trends to stock inventory in advance | | Strategic decision-making | Set direction on evidence instead of gut feeling | Choosing new store locations based on regional profitability analysis | | Fueling AI | Good data makes good AI models | Training a customer service agent on past support conversations |

Exam tip: If a question asks for "the most important factor in improving an AI model's performance," the answer is usually high-quality data. Remember that data is both the subject of analysis and the fuel that runs AI.

---

 

Databases, Data Warehouses, and Data Lakes

The three stores have different purposes. A database is like a store's checkout counter, recording transactions quickly. A data warehouse is like a well-organized library that holds data refined for analysis. A data lake is like a huge warehouse that piles up raw data first, whatever its format.

| Aspect | Database | Data warehouse | Data lake | |------|------|------|------| | Main purpose | Everyday transaction processing (OLTP) | Large-scale analysis (OLAP) and reporting | Storing large volumes of raw data as is | | Shape of the data | Mostly structured | Cleaned and integrated structured and semi-structured | Structured, semi-structured, and unstructured | | When the structure is defined | Before storing | Before storing (loaded after cleaning) | When reading (store first) | | Main users | Applications | Analysts and executives | Data scientists and data engineers | | Google Cloud examples | Cloud SQL, AlloyDB, Spanner, Firestore | BigQuery | Cloud Storage |

These days many organizations also use a lakehouse, which combines the flexibility of a lake with the management capabilities of a warehouse. On Google Cloud, BigQuery and Lakehouse (renamed from BigLake in April 2026) let multiple engines such as BigQuery and Spark share data stored in open table formats like Apache Iceberg.

Exam tip: "The store behind an app that takes orders and decrements inventory" is a database. "Combine data from several systems to produce management reports" is a data warehouse (BigQuery). "Keep logs, images, and sensor data cheaply without processing them first" is a data lake (Cloud Storage).

---

 

Types of Data: Who Collected It and What Shape It Takes

By Source: First-, Second-, and Third-Party Data

| Type | Meaning | Example | Characteristics | |------|------|------|------| | First-party data | Collected directly by your organization at its own customer touchpoints | Website visits, purchase history, app usage data | Most accurate and trustworthy; requires managing customer consent | | Second-party data | Another organization's first-party data shared directly with you under an agreement | Customer data shared between a partnered airline and hotel | Comes from a partner whose source is clear | | Third-party data | Data gathered from many sources and sold by a party with no relationship to the original collector | Demographic and interest data sold by a data vendor | Broad coverage, but accuracy and origin are hard to verify |

By Shape: Structured, Semi-structured, and Unstructured

| Type | Characteristics | Examples | |------|------|------| | Structured data | A fixed table format of rows and columns | Order tables, sales data | | Semi-structured data | Not a table, but has some structure through tags or key-value pairs | JSON, XML, event logs | | Unstructured data | No predefined format | Images, video, audio, email bodies |

Exam tip: "A partner shared its own customer data directly with us under a contract" is second-party data. "Data collected directly from our app" is first-party, and "data purchased from an outside vendor" is third-party.

---

 

The Data Supply Chain: From Genesis to Activation

Just as produce is harvested in the field and goes through sorting, packaging, and storage before it reaches the table, data goes through several stages from the moment it is created to the moment it creates real value. The exam guide calls this flow the data supply chain and divides it into six stages.

!The six stages of the data supply chain: genesis, collection, processing, storage, analysis, and activation, with Google Cloud products for each

| Stage | What happens | Google Cloud examples | |------|------|------| | Genesis | Data is first created | App clicks, payments, IoT sensors, system logs | | Collection | Data is gathered from many sources | Pub/Sub, Storage Transfer Service, BigQuery Data Transfer Service | | Processing | Data is cleaned, transformed, and combined | Dataflow, Managed Service for Apache Spark | | Storage | Data is kept in the store that fits its use | Cloud Storage, BigQuery, Cloud SQL | | Analysis | Questions are asked to find patterns and insights | BigQuery, BigQuery ML | | Activation | Insights are connected to real actions and work | Looker dashboards, alerts, personalized recommendations, AI agents |

The stage people most often overlook is activation. If analysis ends as a report, it creates no value. Once you find the customers most likely to churn, the list has to flow into the marketing system and discount coupons have to go out before it becomes business value.

Exam tip: "The stage that connects analysis results to real business systems and decisions" is data activation. Questions about the order of the stages also appear, so remember genesis → collection → processing → storage → analysis → activation.

---

 

Data Governance: Data You Can Trust

Data governance is like a librarian. The librarian keeps a catalog of where every book is, decides who can borrow what, and pulls damaged books so everyone can rely on the collection. The more data an organization has, the more this management matters; without it, nobody trusts the data.

| Governance area | What it does | Google Cloud examples | |------|------|------| | Discovery and catalog | Lists what data exists and where, and defines business terms | Knowledge Catalog (formerly Dataplex Universal Catalog) | | Data quality | Checks quality aspects such as accuracy and completeness | Knowledge Catalog's data quality features | | Lineage | Tracks where data came from and how it was transformed | Knowledge Catalog's lineage features | | Access control | Decides who can see which data | IAM, BigQuery column-level and row-level security | | Protection and compliance | Finds and masks sensitive data and manages retention | Sensitive Data Protection |

Data governance matters for these reasons:

It lets you comply with regulations such as privacy laws It prevents the confusion of each department calculating the same metric differently, making decisions more trustworthy It guarantees the quality and origin of the data used to train AI It reduces the risk of sensitive data being exposed to the wrong people

Exam tip: "Track where data came from and what transformations it went through" is data lineage. "Find and catalog data across the organization and manage its quality" points to a data governance tool such as Knowledge Catalog.

---

 

Openness and Interoperability: Avoiding Silos and Vendor Lock-in

A data silo is a state where each department stores its data separately and nobody else can see it. If the sales team's customer information is not connected to the support team's inquiry history, you cannot understand a single customer as a whole. Vendor lock-in is a state where you are tied to one vendor's proprietary formats and tools, making it hard to move anywhere else.

The exam guide stresses that openness and interoperability in data management platforms are critical to eliminating these two problems. First, tell the two terms apart.

Open source: software whose source code is public, so anyone can use, modify, and distribute it (for example, Apache Spark, Kubernetes, PostgreSQL) Open standard: a published specification that anyone can implement (for example, SQL, HTTP, the Apache Iceberg table format)

| Approach | Google Cloud example | Effect | |------|------|------| | Open table formats | Lakehouse (formerly BigLake) and Apache Iceberg | Several engines such as BigQuery, Spark, Flink, and Trino share the same data without copying it | | Multicloud analytics | BigQuery Omni | Analyze data in Amazon S3 or Azure Blob Storage with BigQuery without moving it | | Open source compatibility | Managed Service for Apache Spark, AlloyDB (PostgreSQL compatible) | Keep using existing code and skills | | Unified catalog | Knowledge Catalog | Find and manage scattered data in one place |

Exam tip: "Analyze data that lives in another cloud without moving it" is BigQuery Omni. For "avoid being tied to one vendor's forma

Back to blog list