# Glossary

Every key term from the topic pages, one line each, with a link to the page that explains it. Generated by build\_reference.py.

## A

- ABAC: permissions decided by rules over user, resource and context attributes. See [RBAC and ABAC](<https://wiki.4tm0.net/data/rbac-vs-abac.html>).
- Access review: a periodic check of who has access against who needs it. See [Audit logging](<https://wiki.4tm0.net/data/audit-logging.html>).
- Accuracy: agreement with reality or a trusted source. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Acting as the user: calling downstream systems with the user's identity, not a service's. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- Activation: making data usable where actions happen. See [Reverse ETL and activation](<https://wiki.4tm0.net/data/reverse-etl-activation.html>).
- Activity schema: a model with one table of entity activities over time. See [Other modelling approaches: Data Vault, one big table and activity schema](<https://wiki.4tm0.net/data/other-modelling-approaches.html>).
- Adapter: the plugin that connects dbt to an engine. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- Additive, semi-additive, non-additive: how a measure can be summed. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- Aggregate: the business object an event is about, such as one order. See [The outbox pattern](<https://wiki.4tm0.net/data/outbox-pattern.html>).
- AI agent: a model-driven application that calls tools to answer or act. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- AI inventory: a register of all AI systems with owners, purposes and risk levels. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Allowed lateness: how long a window still accepts updates after its watermark has passed. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Analytics engineer: builds tested models and metrics for consumers. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- Anomaly detection: flagging values that differ from their usual pattern. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Anonymisation: making identification no longer possible. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Apache Arrow: a columnar in-memory format shared by many Python data tools. See [Python on the lakehouse](<https://wiki.4tm0.net/data/python-on-the-lakehouse.html>).
- Apache XTable: a project that translates metadata between table formats. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).
- API contract: the stable definition of endpoints and fields that clients rely on. See [Data APIs and the backend-for-frontend pattern](<https://wiki.4tm0.net/data/data-api-and-bff.html>).
- Append mode: every record becomes a new row. See [Writing to Iceberg from Kafka](<https://wiki.4tm0.net/data/kafka-to-iceberg.html>).
- Approximate nearest neighbour (ANN): fast search that finds close vectors with high, not perfect, accuracy. See [Embeddings, vector search and RAG](<https://wiki.4tm0.net/data/embeddings-vector-search-rag.html>).
- Asset: a data object, such as a table, that the orchestrator tracks and keeps up to date. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- At-least-once: retried until acknowledged; may duplicate messages. See [Delivery guarantees and idempotency](<https://wiki.4tm0.net/data/delivery-guarantees-idempotency.html>).
- At-most-once: never retried; may lose messages. See [Delivery guarantees and idempotency](<https://wiki.4tm0.net/data/delivery-guarantees-idempotency.html>).
- Atomic commit: a pointer change that succeeds only if the table has not changed since the writer started. See [Catalogs](<https://wiki.4tm0.net/data/catalogs.html>).
- Atomic swap: replacing a published table with a staged one in one operation. See [Write-audit-publish](<https://wiki.4tm0.net/data/write-audit-publish.html>).
- Audit: the checks run between writing and publishing. See [Write-audit-publish](<https://wiki.4tm0.net/data/write-audit-publish.html>).
- Audit log: a record of security-relevant actions: who, what, which resource, when, result. See [Audit logging](<https://wiki.4tm0.net/data/audit-logging.html>).
- Authentication: verifying who is making a request. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).
- Authorization: deciding whether a request is allowed. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).

## B

- Backend-for-frontend (BFF): an API dedicated to one client application. See [Data APIs and the backend-for-frontend pattern](<https://wiki.4tm0.net/data/data-api-and-bff.html>).
- Backfill: running a pipeline for past periods. See [Backfill and replay](<https://wiki.4tm0.net/data/backfill-and-replay.html>).
- Backward compatibility: new readers can read old data. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Batch serving: scoring on a schedule and writing predictions to a table. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Bin-packing: compaction that combines files without reordering rows. See [Iceberg maintenance](<https://wiki.4tm0.net/data/iceberg-maintenance.html>).
- Blocking test: a test whose failure stops publishing. See [Testing data pipelines](<https://wiki.4tm0.net/data/testing-data-pipelines.html>).
- Bounded data: a finite set with a known end, as processed by a batch. See [Processing patterns: batch, micro-batch and streaming](<https://wiki.4tm0.net/data/processing-patterns.html>).
- Branch: a named, independent line of snapshots in a table. See [Write-audit-publish](<https://wiki.4tm0.net/data/write-audit-publish.html>).
- Breaking change: a change that existing readers or writers cannot handle under the agreed compatibility mode, or that changes meaning; removing a field consumers use is breaking even when the registry allows it. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Breaking change (Data contracts): a change that can break consumers, requiring a new major version. See [Data contracts](<https://wiki.4tm0.net/data/data-contracts.html>).
- Broker: the server that receives MQTT messages and forwards them to subscribers. See [IoT and device data](<https://wiki.4tm0.net/data/iot-and-device-data.html>).
- Bronze (raw): data as delivered, append-only, kept for rebuilding. See [Medallion layers: bronze, silver and gold](<https://wiki.4tm0.net/data/medallion-layers.html>).
- Bucket: a named container for objects, with a region and access policy. See [Object storage and the S3 API](<https://wiki.4tm0.net/data/object-storage.html>).
- Bucket versioning: keeping previous versions of overwritten or deleted objects. See [Disaster recovery](<https://wiki.4tm0.net/data/disaster-recovery.html>).
- Bucketing: assigning rows to a fixed number of groups by a hash of a key. See [Partitioning](<https://wiki.4tm0.net/data/partitioning.html>).
- Business catalog: a searchable inventory of datasets with business context. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).
- Business glossary: agreed definitions of business terms. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).
- Business intelligence (BI): tools and practices for reporting and exploring business data. See [BI and dashboards](<https://wiki.4tm0.net/data/bi-and-dashboards.html>).
- Business key: the identifier of an entity in the source, such as order\_id. See [Deduplication and merge](<https://wiki.4tm0.net/data/deduplication-and-merge.html>).
- Business metadata: meaning and responsibility, such as descriptions, owners and terms. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).

## C

- Canary release: sending a small share of traffic to a new version first. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Cardinality: the number of distinct values of a column. See [Partitioning](<https://wiki.4tm0.net/data/partitioning.html>).
- Casting: converting a value to a declared type when reading or transforming. See [Schema-on-write and schema-on-read](<https://wiki.4tm0.net/data/schema-on-write-vs-read.html>).
- Catalog: the service that knows where each table's current metadata.json is. Every commit goes through it. See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Catastrophic forgetting: a fine-tuned model losing general abilities it had before. See [Fine-tuning or RAG](<https://wiki.4tm0.net/data/fine-tuning-vs-rag.html>).
- CDC metadata columns: operation, source position and commit time kept alongside each change row. See [Writing to Iceberg from Kafka](<https://wiki.4tm0.net/data/kafka-to-iceberg.html>).
- Certification: marking a dashboard or dataset as trusted and supported. See [BI and dashboards](<https://wiki.4tm0.net/data/bi-and-dashboards.html>).
- Change event: one row change, with before, after, operation and source metadata. See [Change data capture](<https://wiki.4tm0.net/data/change-data-capture.html>).
- Change-based sync: sending only rows that changed since the last sync. See [Reverse ETL and activation](<https://wiki.4tm0.net/data/reverse-etl-activation.html>).
- Checkpoint: a consistent snapshot of state and source offsets, used to recover. See [Stream processing](<https://wiki.4tm0.net/data/stream-processing.html>).
- Chunk: a section of a document, embedded and retrieved as a unit. See [Embeddings, vector search and RAG](<https://wiki.4tm0.net/data/embeddings-vector-search-rag.html>).
- Class imbalance: when one outcome is much rarer than others. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).
- Classification level: a label, such as confidential, that decides handling rules. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Classification tag: a label on a column or table marking its sensitivity. See [Governance as code](<https://wiki.4tm0.net/data/governance-as-code.html>).
- Client credentials flow: how a service obtains a token as itself. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).
- CloudEvents: a CNCF specification for common event metadata. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Clustering: placing similar values together, by sorting or Z-ordering, so statistics can skip. See [Query performance on lake tables](<https://wiki.4tm0.net/data/query-performance.html>).
- Column bounds: the lowest and highest value of a column in one data file. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Column chunk: the values of one column within one row group. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Column mask: an expression that hides or reduces a column's values for a user. See [Row-level security and masking](<https://wiki.4tm0.net/data/row-level-security-masking.html>).
- Column-level lineage: lineage between individual columns. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).
- Column-oriented storage: all values of a column stored together. See [OLTP vs OLAP](<https://wiki.4tm0.net/data/oltp-vs-olap.html>).
- Command: a request for something to happen, which may be refused. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Commit interval: how often written files are committed to the table. See [Writing to Iceberg from Kafka](<https://wiki.4tm0.net/data/kafka-to-iceberg.html>).
- Compacted topic: a topic that keeps the latest record per key. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- Compaction: rewriting small files, and their delete files, into fewer large files. See [Iceberg maintenance](<https://wiki.4tm0.net/data/iceberg-maintenance.html>).
- Compatibility mode: the rule a registry enforces for a subject, usually one per topic key or value. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Completeness: no missing records or required values. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Concept drift: change in the relationship between inputs and outcomes. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Concurrency: the number of queries served at the same time. See [Low-latency serving stores](<https://wiki.4tm0.net/data/low-latency-serving-stores.html>).
- Conditional write: a write that succeeds only if the object is absent or unchanged. See [Object storage and the S3 API](<https://wiki.4tm0.net/data/object-storage.html>).
- Conformed: using the same keys, names and codes across sources. See [Medallion layers: bronze, silver and gold](<https://wiki.4tm0.net/data/medallion-layers.html>).
- Conformed dimension: a dimension shared, with the same meaning, by several facts. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- Confounder: a factor that influences both a cause and an effect, creating a false association. See [The data science workflow](<https://wiki.4tm0.net/data/data-science-workflow.html>).
- Connector: a configured source or sink in Kafka Connect. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- Connector (SQL query engines): a plugin that lets the engine read and write one kind of system. See [SQL query engines](<https://wiki.4tm0.net/data/sql-query-engines.html>).
- Consistency: agreement of the same fact across tables and systems. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Consumer: uses data within agreed purposes and terms. See [Governance roles](<https://wiki.4tm0.net/data/governance-roles.html>).
- Consumer (Data contracts): anyone who relies on the dataset. See [Data contracts](<https://wiki.4tm0.net/data/data-contracts.html>).
- Consumer group: consumers that share the work of reading a topic, with their own committed offsets. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- Continuous integration (CI): automatic checks run on every proposed change. See [Environments and CI](<https://wiki.4tm0.net/data/environments-and-ci.html>).
- Control and treatment: the groups that see the current and the changed version. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Control topic: the topic on which sink tasks and the coordinator exchange commit information. See [Writing to Iceberg from Kafka](<https://wiki.4tm0.net/data/kafka-to-iceberg.html>).
- Coordinator: the process that plans a query and schedules work. See [SQL query engines](<https://wiki.4tm0.net/data/sql-query-engines.html>).
- Correlation ID: an ID that links events belonging to one process. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Cosine similarity: a measure of how close two vectors point in the same direction. See [Embeddings, vector search and RAG](<https://wiki.4tm0.net/data/embeddings-vector-search-rag.html>).
- Cost attribution: assigning spend to teams, products or workloads. See [Cost and FinOps](<https://wiki.4tm0.net/data/cost-finops.html>).
- Credential vending: the catalog issuing short-lived storage credentials scoped to one table. See [Catalogs](<https://wiki.4tm0.net/data/catalogs.html>).
- Cross-border transfer: data, or access to it, moving from one jurisdiction to another. See [Residency and regions](<https://wiki.4tm0.net/data/residency-and-regions.html>).
- Cross-reference table: the record of which source IDs belong to which platform ID. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Crypto-shredding: making data unreadable by destroying its encryption key. See [Privacy lifecycle](<https://wiki.4tm0.net/data/privacy-lifecycle.html>).
- Curated dashboard: a reviewed, owned dashboard intended as an official source. See [BI and dashboards](<https://wiki.4tm0.net/data/bi-and-dashboards.html>).
- Cursor: a position token returned by an API to continue reading. See [Ingestion patterns](<https://wiki.4tm0.net/data/ingestion-patterns.html>).
- Cursor pagination: paging with a token that marks where the next page starts. See [Data APIs and the backend-for-frontend pattern](<https://wiki.4tm0.net/data/data-api-and-bff.html>).
- Customer-managed key: an encryption key controlled by the organisation, not the provider. See [Encryption and key management](<https://wiki.4tm0.net/data/encryption-and-key-management.html>).
- Cutover: moving consumers from the old platform to the new one. See [Platform migration](<https://wiki.4tm0.net/data/platform-migration.html>).

## D

- DAG: a directed acyclic graph of tasks and their dependencies. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- Data analyst: answers business questions with reports and analysis. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- Data API: an HTTP interface returning records from platform data. See [Data APIs and the backend-for-frontend pattern](<https://wiki.4tm0.net/data/data-api-and-bff.html>).
- Data contract: a machine-readable agreement on a dataset's schema, meaning, quality and service levels. See [Data contracts](<https://wiki.4tm0.net/data/data-contracts.html>).
- Data custodian: operates the systems that store and move the data. See [Governance roles](<https://wiki.4tm0.net/data/governance-roles.html>).
- Data diff: comparing the output of a changed model with production. See [Environments and CI](<https://wiki.4tm0.net/data/environments-and-ci.html>).
- Data drift: change in the distribution of a model's inputs. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Data engineer: builds ingestion and the reliable lower layers. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- Data lake: files of any format in object storage, without table rules. See [Data lake, warehouse and lakehouse](<https://wiki.4tm0.net/data/lake-warehouse-lakehouse.html>).
- Data localisation: a legal requirement that certain data stays within a country. See [Residency and regions](<https://wiki.4tm0.net/data/residency-and-regions.html>).
- Data minimisation: collecting and keeping only what is needed. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Data owner: accountable for a dataset; makes decisions about its use and quality. See [Governance roles](<https://wiki.4tm0.net/data/governance-roles.html>).
- Data product: a published dataset with an owner, interface, contract and documentation. See [Data products and data mesh](<https://wiki.4tm0.net/data/data-products-and-mesh.html>).
- Data product owner: accountable for a data product's value to its consumers. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- Data residency: the location where data is stored and processed. See [Residency and regions](<https://wiki.4tm0.net/data/residency-and-regions.html>).
- Data scientist: uses statistics and models to investigate and predict. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- Data sovereignty: data being subject to the laws of where it is held, or of who holds it. See [Residency and regions](<https://wiki.4tm0.net/data/residency-and-regions.html>).
- Data steward: manages definitions, access reviews and quality issues day to day. See [Governance roles](<https://wiki.4tm0.net/data/governance-roles.html>).
- Data test: a query that returns rows breaking a business rule. See [Testing data pipelines](<https://wiki.4tm0.net/data/testing-data-pipelines.html>).
- Data Vault: a modelling method using hubs, links and satellites for integration and history. See [Other modelling approaches: Data Vault, one big table and activity schema](<https://wiki.4tm0.net/data/other-modelling-approaches.html>).
- Data warehouse: an analytical database that manages its own storage format. See [Data lake, warehouse and lakehouse](<https://wiki.4tm0.net/data/lake-warehouse-lakehouse.html>).
- Dataframe: an in-memory table manipulated with code. See [Python on the lakehouse](<https://wiki.4tm0.net/data/python-on-the-lakehouse.html>).
- Dataset version: an identifiable, reproducible state of a dataset, such as a table tag. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).
- Datasheet for datasets: documentation of a dataset's origin, content and permitted uses. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Declarative: describing the desired end state rather than the steps to reach it. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- Declarative configuration: describing the desired state, and letting tools make the systems match it. See [Governance as code](<https://wiki.4tm0.net/data/governance-as-code.html>).
- Decommissioning: switching off the old platform once nothing uses it. See [Platform migration](<https://wiki.4tm0.net/data/platform-migration.html>).
- Delete file: records which rows a later commit removed. Position deletes point at row positions; equality deletes match on column values. See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Deletion vector: a bitmap marking deleted rows of one data file, in format version 3. See [Iceberg maintenance](<https://wiki.4tm0.net/data/iceberg-maintenance.html>).
- Deletion vector (Table formats compared: Iceberg, Delta Lake, Hudi and Paimon): a per-file record of deleted rows, used by Delta Lake and Iceberg v3. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).
- Denormalised model: related data combined into wider tables to avoid joins. See [OLTP vs OLAP](<https://wiki.4tm0.net/data/oltp-vs-olap.html>).
- Deterministic matching: matching on exact, normalised identifiers. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Dialect translation: converting SQL and functions from one engine to another. See [Platform migration](<https://wiki.4tm0.net/data/platform-migration.html>).
- Dimension: an attribute that metrics are grouped or filtered by. See [Semantic layer](<https://wiki.4tm0.net/data/semantic-layer.html>).
- Dimension table: descriptive context for facts, one row per member. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- Direct identifier: a value that identifies a person on its own. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Distillation: training a smaller model to reproduce a larger model's outputs on a task. See [Fine-tuning or RAG](<https://wiki.4tm0.net/data/fine-tuning-vs-rag.html>).
- Domain: a business area with its own team, data and language, such as orders or payments. See [Data products and data mesh](<https://wiki.4tm0.net/data/data-products-and-mesh.html>).
- Drift: a difference between declared and actual configuration. See [Governance as code](<https://wiki.4tm0.net/data/governance-as-code.html>).
- Drift (Infrastructure as code): differences between declared and actual infrastructure. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- Dual write: writing to two systems separately, with no way to commit both together. See [The outbox pattern](<https://wiki.4tm0.net/data/outbox-pattern.html>).
- Dynamic masking: masking applied at query time, depending on the user. See [Row-level security and masking](<https://wiki.4tm0.net/data/row-level-security-masking.html>).

## E

- Effective dates: valid\_from and valid\_to of a version. See [History and slowly changing dimensions](<https://wiki.4tm0.net/data/history-and-scd.html>).
- Egress: data transferred out of a region or cloud, usually charged. See [Cost and FinOps](<https://wiki.4tm0.net/data/cost-finops.html>).
- Embedding: a vector representing the meaning of a piece of content. See [Embeddings, vector search and RAG](<https://wiki.4tm0.net/data/embeddings-vector-search-rag.html>).
- Encoding: a compact representation of values, such as dictionary or run-length. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Encryption at rest: protecting stored data. See [Encryption and key management](<https://wiki.4tm0.net/data/encryption-and-key-management.html>).
- Encryption in transit: protecting data on the network, usually with TLS. See [Encryption and key management](<https://wiki.4tm0.net/data/encryption-and-key-management.html>).
- Enforcement point: the component that applies filters and masks. See [Row-level security and masking](<https://wiki.4tm0.net/data/row-level-security-masking.html>).
- Entity: the thing features describe, such as a customer or product. See [Feature engineering and feature stores](<https://wiki.4tm0.net/data/feature-engineering-feature-stores.html>).
- Envelope: standard metadata fields carried by every event. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Envelope encryption: encrypting data with data keys that are themselves encrypted by a master key. See [Encryption and key management](<https://wiki.4tm0.net/data/encryption-and-key-management.html>).
- Environment: an isolated place to build and run pipelines, such as dev, CI or prod. See [Environments and CI](<https://wiki.4tm0.net/data/environments-and-ci.html>).
- Erasure request: a request to delete all personal data about one person. See [Privacy lifecycle](<https://wiki.4tm0.net/data/privacy-lifecycle.html>).
- Error budget: the amount of failure the SLO allows. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).
- Evaluation set: versioned inputs with criteria or references for good outputs. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).
- Event: a record of a fact that happened. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Event ID: a unique, producer-generated ID used by consumers to deduplicate. See [The outbox pattern](<https://wiki.4tm0.net/data/outbox-pattern.html>).
- Event listener: an engine plugin that receives events, such as completed queries. See [Audit logging](<https://wiki.4tm0.net/data/audit-logging.html>).
- Event time: when the event happened. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Exactly-once: each message affects the result once, through deduplication or transactions. See [Delivery guarantees and idempotency](<https://wiki.4tm0.net/data/delivery-guarantees-idempotency.html>).
- Exactly-once processing: each event affects state once, even after failures. See [Stream processing](<https://wiki.4tm0.net/data/stream-processing.html>).
- Example: one case to predict for, with an entity and a time. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).
- Exchange: moving intermediate rows between workers, for example to group or join by key. See [SQL query engines](<https://wiki.4tm0.net/data/sql-query-engines.html>).
- Expand and contract: making a breaking change in compatible steps. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Experiment tracking: recording parameters, data, metrics and outputs of every run. See [The ML lifecycle and MLOps](<https://wiki.4tm0.net/data/ml-lifecycle-mlops.html>).
- Explainability: the ability to give reasons for a model's predictions. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Exploratory data analysis (EDA): examining data to understand it before testing hypotheses. See [The data science workflow](<https://wiki.4tm0.net/data/data-science-workflow.html>).
- Export: a copy of data sent to someone, outside the provider's control. See [Data sharing](<https://wiki.4tm0.net/data/data-sharing.html>).
- Exposure: the moment a unit actually experiences its variant. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Extract: reading data out of a source system. See [ETL, ELT and EtLT](<https://wiki.4tm0.net/data/etl-elt-etlt.html>).
- Extract (BI and dashboards): a copy of data stored in the BI tool and refreshed on a schedule. See [BI and dashboards](<https://wiki.4tm0.net/data/bi-and-dashboards.html>).

## F

- Fact table: rows of events or measurements with numeric measures and dimension keys. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- Failover: switching service to a replica in another location. See [Disaster recovery](<https://wiki.4tm0.net/data/disaster-recovery.html>).
- Fairness check: comparing a model's performance or outcomes across groups. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Fast-forward: moving a branch to a later snapshot of another branch. See [Write-audit-publish](<https://wiki.4tm0.net/data/write-audit-publish.html>).
- Fault-tolerant execution: retrying failed parts of a query instead of the whole query. See [SQL query engines](<https://wiki.4tm0.net/data/sql-query-engines.html>).
- Feature: an input variable to a model. See [Feature engineering and feature stores](<https://wiki.4tm0.net/data/feature-engineering-feature-stores.html>).
- Federated governance: shared rules agreed by domain and platform representatives, enforced automatically, with all other decisions left to domains. See [Data products and data mesh](<https://wiki.4tm0.net/data/data-products-and-mesh.html>).
- Federation: one query reading from several systems through connectors. See [SQL query engines](<https://wiki.4tm0.net/data/sql-query-engines.html>).
- File catalog table: a table with one row per file, describing and governing it. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- File skipping: dropping files whose column bounds cannot match a filter. See [Query performance on lake tables](<https://wiki.4tm0.net/data/query-performance.html>).
- Fine-tuning: further training a model on task examples to change its behaviour. See [Fine-tuning or RAG](<https://wiki.4tm0.net/data/fine-tuning-vs-rag.html>).
- FinOps: a practice of shared ownership of cloud cost between engineering and finance. See [Cost and FinOps](<https://wiki.4tm0.net/data/cost-finops.html>).
- Footer: metadata at the end of the file: schema, chunk positions and statistics. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Format version: v2 added row-level deletes; v3 adds deletion vectors and new data types. Engines differ in which versions they support. See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Forward compatibility: old readers can read new data. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Framing: turning a question into a precise metric, population, window and decision. See [The data science workflow](<https://wiki.4tm0.net/data/data-science-workflow.html>).
- Freshness: how old the data is when someone reads it. See [Processing patterns: batch, micro-batch and streaming](<https://wiki.4tm0.net/data/processing-patterns.html>).
- Full compatibility: both directions. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Full load: copying the complete source dataset on every run. See [Ingestion patterns](<https://wiki.4tm0.net/data/ingestion-patterns.html>).

## G

- Generic, singular and unit tests: column checks, custom queries, and logic tests on fixed inputs. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- GitOps: keeping systems in sync with configuration stored in Git. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- Gold (curated): tables shaped for a specific use, with owners and stable definitions. See [Medallion layers: bronze, silver and gold](<https://wiki.4tm0.net/data/medallion-layers.html>).
- Golden record: the combined record after survivorship. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Grain: what exactly one fact row represents. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- Grain in the name: naming a table after what one row represents. See [Naming conventions](<https://wiki.4tm0.net/data/naming-conventions.html>).
- Granularity: how much change one event describes. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Groundedness: whether an answer is supported by the retrieved sources. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).
- Guardrail: a check that blocks or corrects unsafe inputs or outputs. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).

## H

- Headless semantic layer: a standalone service exposing metrics through APIs to any tool. See [Semantic layer](<https://wiki.4tm0.net/data/semantic-layer.html>).
- Hidden partitioning: the table derives partition values from a column by a stored rule. See [Partitioning](<https://wiki.4tm0.net/data/partitioning.html>).
- High-risk AI system: under the EU AI Act, a system in a listed sensitive area with strict requirements. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Hive-style partitioning: partition values written into file paths as key=value. See [Partitioning](<https://wiki.4tm0.net/data/partitioning.html>).
- Home region: the region a record belongs to, decided by a rule such as residence. See [Residency and regions](<https://wiki.4tm0.net/data/residency-and-regions.html>).
- Hub: a table of unique business keys. See [Other modelling approaches: Data Vault, one big table and activity schema](<https://wiki.4tm0.net/data/other-modelling-approaches.html>).
- Human oversight: people able to review, override and monitor an AI system. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Hybrid search: combining vector similarity with keyword matching. See [Embeddings, vector search and RAG](<https://wiki.4tm0.net/data/embeddings-vector-search-rag.html>).
- Hypothesis: a candidate explanation that predicts something checkable in the data. See [The data science workflow](<https://wiki.4tm0.net/data/data-science-workflow.html>).

## I

- Iceberg REST catalog: the HTTP API, defined by the Iceberg project, that engines use to talk to a catalog. See [Catalogs](<https://wiki.4tm0.net/data/catalogs.html>).
- Idempotency key: a stable ID used to recognise repeats of the same event. See [Delivery guarantees and idempotency](<https://wiki.4tm0.net/data/delivery-guarantees-idempotency.html>).
- Idempotent model: a model that gives the same result when re-run for the same period. See [Backfill and replay](<https://wiki.4tm0.net/data/backfill-and-replay.html>).
- Idempotent operation: one that gives the same result when repeated. See [Delivery guarantees and idempotency](<https://wiki.4tm0.net/data/delivery-guarantees-idempotency.html>).
- Idempotent producer: a Kafka producer whose retries are deduplicated by the broker. See [Delivery guarantees and idempotency](<https://wiki.4tm0.net/data/delivery-guarantees-idempotency.html>).
- Identifier mapping: the field used to match a row to a record in the target. See [Reverse ETL and activation](<https://wiki.4tm0.net/data/reverse-etl-activation.html>).
- Identity provider: the service that authenticates users and issues tokens. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).
- Identity resolution: assigning one platform ID to all records of one entity. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Incremental load: copying only what changed since the previous run. See [Ingestion patterns](<https://wiki.4tm0.net/data/ingestion-patterns.html>).
- Incremental model: a model that processes only new or changed rows on each run. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- Indirect identifier: a value that can identify a person in combination with others. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Infrastructure as code (IaC): managing infrastructure through declarative, version-controlled files. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- Ingestion time: when the event reached the platform. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Inventory: the list of assets and consumers on the old platform, with usage. See [Platform migration](<https://wiki.4tm0.net/data/platform-migration.html>).
- Isolation model: how tenants are separated: shared tables, schema per tenant, or stack per tenant. See [Multi-tenancy](<https://wiki.4tm0.net/data/multi-tenancy.html>).

## J

- JWT: a signed token carrying claims, verified with the issuer's public keys. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).

## K

- Key: the full name of an object within a bucket. See [Object storage and the S3 API](<https://wiki.4tm0.net/data/object-storage.html>).
- Key management service (KMS): a service that holds keys and performs key operations under access control. See [Encryption and key management](<https://wiki.4tm0.net/data/encryption-and-key-management.html>).
- Key-value store: a database that returns records by key with very low latency. See [Low-latency serving stores](<https://wiki.4tm0.net/data/low-latency-serving-stores.html>).

## L

- Label: the known outcome a model learns to predict. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).
- Lakehouse: open files in object storage plus an open table format and a catalog. See [Data lake, warehouse and lakehouse](<https://wiki.4tm0.net/data/lake-warehouse-lakehouse.html>).
- Lance: an open columnar format designed for multimodal data with fast random access. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- Landing: writing data to the raw layer as delivered, with load metadata. See [Ingestion patterns](<https://wiki.4tm0.net/data/ingestion-patterns.html>).
- Latency: how long processing takes, from an event arriving to its result being available. See [Processing patterns: batch, micro-batch and streaming](<https://wiki.4tm0.net/data/processing-patterns.html>).
- Lateness: the delay between event time and processing time. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Lazy evaluation: building a query plan first and running it once, so only needed data is read. See [Python on the lakehouse](<https://wiki.4tm0.net/data/python-on-the-lakehouse.html>).
- Leakage: features containing information not available at prediction time. See [Feature engineering and feature stores](<https://wiki.4tm0.net/data/feature-engineering-feature-stores.html>).
- Least privilege: granting only the access a user or service needs. See [RBAC and ABAC](<https://wiki.4tm0.net/data/rbac-vs-abac.html>).
- Lineage: the dependencies between datasets, jobs and reports. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).
- Link: a table of relationships between business keys. See [Other modelling approaches: Data Vault, one big table and activity schema](<https://wiki.4tm0.net/data/other-modelling-approaches.html>).
- Live query: a dashboard query sent to the engine each time it is viewed. See [BI and dashboards](<https://wiki.4tm0.net/data/bi-and-dashboards.html>).
- LLM-as-a-judge: using a model to score outputs against criteria. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).
- LLMOps: practices for building, evaluating and operating LLM applications. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).
- Load: writing data into the target store. See [ETL, ELT and EtLT](<https://wiki.4tm0.net/data/etl-elt-etlt.html>).
- Load metadata: columns added during loading, such as source system and ingestion time. See [ETL, ELT and EtLT](<https://wiki.4tm0.net/data/etl-elt-etlt.html>).
- Log-based CDC: reading changes from the database's transaction log. See [Change data capture](<https://wiki.4tm0.net/data/change-data-capture.html>).
- Logical date: the period a run processes, independent of when it runs. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- LoRA: a parameter-efficient fine-tuning method that trains small added weight matrices. See [Fine-tuning or RAG](<https://wiki.4tm0.net/data/fine-tuning-vs-rag.html>).
- LSM tree: a log-structured merge tree, a storage design optimised for frequent writes. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).

## M

- Manifest: a list of files with per-column statistics, used to skip files that cannot match a query. See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Manifest (Iceberg internals: manifests and planning): an Avro file listing data or delete files with their partition and column metrics. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Manifest list: the per-snapshot list of manifests, with a partition summary for each. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Mapping: aligning fields, types and codes of several sources to one structure. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Materialization: how a model is built: view, table, incremental, ephemeral. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- MCP host: the application in which the agent runs and connects to servers. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- MCP server: a service that exposes tools over MCP. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- MERGE: one statement that inserts, updates and deletes rows in a target based on a source. See [Deduplication and merge](<https://wiki.4tm0.net/data/deduplication-and-merge.html>).
- Metadata column: a column added by the platform, such as `_ingested_at`. See [Naming conventions](<https://wiki.4tm0.net/data/naming-conventions.html>).
- Metadata file (metadata.json): the root of the tree, holding the schema, partitioning and snapshot list. See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Metadata table: a read-only table exposing metadata, such as $files or $manifests. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Metric: a named calculation with business meaning, such as revenue. See [Semantic layer](<https://wiki.4tm0.net/data/semantic-layer.html>).
- Metric, log, trace: numeric measurements over time, event records, and the path of one request or run across components. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).
- Metrics API: an interface that returns metric values by dimension. See [Semantic layer](<https://wiki.4tm0.net/data/semantic-layer.html>).
- Metrics API (Data APIs and the backend-for-frontend pattern): an interface returning aggregated metric values. See [Data APIs and the backend-for-frontend pattern](<https://wiki.4tm0.net/data/data-api-and-bff.html>).
- ML engineer: puts models into production and keeps them running. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- MLOps: practices for building, deploying and operating models reliably. See [The ML lifecycle and MLOps](<https://wiki.4tm0.net/data/ml-lifecycle-mlops.html>).
- Model: one SELECT statement in a file, built into a table or view. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- Model card: documentation of a model's purpose, performance, evaluation and limits. See [Responsible AI and AI governance](<https://wiki.4tm0.net/data/responsible-ai-governance.html>).
- Model Context Protocol (MCP): an open standard for exposing tools, resources and prompts to agents. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- Model registry: a catalog of model versions with metadata, status and approvals. See [The ML lifecycle and MLOps](<https://wiki.4tm0.net/data/ml-lifecycle-mlops.html>).
- Model signature: the declared input and output schema of a model. See [The ML lifecycle and MLOps](<https://wiki.4tm0.net/data/ml-lifecycle-mlops.html>).
- Module: a reusable package of infrastructure declarations. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- MQTT: a light publish and subscribe protocol for devices and unreliable networks. See [IoT and device data](<https://wiki.4tm0.net/data/iot-and-device-data.html>).
- Multimodal data: data combining several types, such as images with text. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- Multipart upload: uploading a large object in parts that become visible together. See [Object storage and the S3 API](<https://wiki.4tm0.net/data/object-storage.html>).

## N

- Namespace: a grouping of tables, like a schema in a database. See [Catalogs](<https://wiki.4tm0.net/data/catalogs.html>).
- Naming convention: an agreed rule for names, enforced in review or CI. See [Naming conventions](<https://wiki.4tm0.net/data/naming-conventions.html>).
- Noisy neighbour: a tenant whose load degrades performance for others. See [Multi-tenancy](<https://wiki.4tm0.net/data/multi-tenancy.html>).
- Normalised model: each fact stored once, across many related tables. See [OLTP vs OLAP](<https://wiki.4tm0.net/data/oltp-vs-olap.html>).
- Notebook: an interactive document of code, results and notes. See [Python on the lakehouse](<https://wiki.4tm0.net/data/python-on-the-lakehouse.html>).

## O

- OAuth 2.0: a framework for issuing access tokens to clients. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).
- Object lock: write-once retention that prevents deletion for a period. See [Disaster recovery](<https://wiki.4tm0.net/data/disaster-recovery.html>).
- Observability: understanding a system's state from the signals it emits. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).
- OCR: reading text from images of documents. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- ODCS: the Open Data Contract Standard, a YAML format for contracts. See [Data contracts](<https://wiki.4tm0.net/data/data-contracts.html>).
- Offline and online store: historical feature values for training, and latest values for low-latency serving. See [Feature engineering and feature stores](<https://wiki.4tm0.net/data/feature-engineering-feature-stores.html>).
- Offset: a record's position within a partition. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- On-behalf-of identity: the user for whom a service performs an action. See [Audit logging](<https://wiki.4tm0.net/data/audit-logging.html>).
- One big table (OBT): a single wide denormalised table for a specific use. See [Other modelling approaches: Data Vault, one big table and activity schema](<https://wiki.4tm0.net/data/other-modelling-approaches.html>).
- Online serving: scoring per request behind an API, with low latency. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Open table format: a specification that turns a set of files into a table with transactions and a schema. See [Data lake, warehouse and lakehouse](<https://wiki.4tm0.net/data/lake-warehouse-lakehouse.html>).
- Open table format (Table formats compared: Iceberg, Delta Lake, Hudi and Paimon): a specification that turns files into tables with versions and atomic commits. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).
- Open-weight model: a model whose weights can be downloaded and run on own infrastructure. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).
- OpenID Connect: an identity layer on OAuth 2.0 that adds login and ID tokens. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).
- OpenLineage: an open standard for emitting lineage events from running jobs. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).
- Orphan file: a file in the table location that no snapshot references. See [Iceberg maintenance](<https://wiki.4tm0.net/data/iceberg-maintenance.html>).
- Out-of-core processing: handling data larger than memory by spilling to disk. See [Python on the lakehouse](<https://wiki.4tm0.net/data/python-on-the-lakehouse.html>).
- Outbox routing: sending outbox rows to topics by event type or aggregate. See [The outbox pattern](<https://wiki.4tm0.net/data/outbox-pattern.html>).
- Outbox table: a table in the service's database holding events to publish. See [The outbox pattern](<https://wiki.4tm0.net/data/outbox-pattern.html>).
- Output port: the published interface of a data product. See [Data products and data mesh](<https://wiki.4tm0.net/data/data-products-and-mesh.html>).

## P

- Page: the unit of encoding and compression inside a column chunk. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Parallel run: running old and new pipelines side by side and comparing outputs. See [Platform migration](<https://wiki.4tm0.net/data/platform-migration.html>).
- Parsing: extracting text and structure from documents. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- Partition: an ordered, append-only part of a topic; the unit of ordering and parallelism. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- Partition key: the column, or derived value, that decides which partition a row belongs to. See [Partitioning](<https://wiki.4tm0.net/data/partitioning.html>).
- Partition pruning: skipping partitions that cannot match a query's filter. See [Partitioning](<https://wiki.4tm0.net/data/partitioning.html>).
- Partition summary: the lowest and highest partition values in one manifest. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Partition transform: the rule that derives partition values, such as day(ordered\_at) or bucket(16, customer\_id). See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Partition-scoped run: a run that processes and writes exactly one period. See [Backfill and replay](<https://wiki.4tm0.net/data/backfill-and-replay.html>).
- Peeking: repeatedly checking results and stopping early. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Personal data (PII): information relating to an identified or identifiable person. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Physical deletion: the data no longer exists in any file, as opposed to being hidden from queries. See [Privacy lifecycle](<https://wiki.4tm0.net/data/privacy-lifecycle.html>).
- Plan: a preview of the changes an apply would make. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- Platform engineer: builds and operates the shared data platform. See [Data team roles](<https://wiki.4tm0.net/data/data-team-roles.html>).
- Platform team: provides shared tooling and enforces cross-cutting rules. See [Governance roles](<https://wiki.4tm0.net/data/governance-roles.html>).
- Point-in-time join: joining on a key and a time within the validity range. See [History and slowly changing dimensions](<https://wiki.4tm0.net/data/history-and-scd.html>).
- Point-in-time join (Feature engineering and feature stores): matching each example with feature values as they were at its time. See [Feature engineering and feature stores](<https://wiki.4tm0.net/data/feature-engineering-feature-stores.html>).
- Policy as code: access and handling rules written in files, often in a policy language, and tested. See [Governance as code](<https://wiki.4tm0.net/data/governance-as-code.html>).
- Policy decision point: the component that evaluates access rules. See [RBAC and ABAC](<https://wiki.4tm0.net/data/rbac-vs-abac.html>).
- Policy enforcement point: the component that applies the decision to a request. See [RBAC and ABAC](<https://wiki.4tm0.net/data/rbac-vs-abac.html>).
- Policy engine: a service that evaluates policies at request time, such as Open Policy Agent. See [Governance as code](<https://wiki.4tm0.net/data/governance-as-code.html>).
- Power: the probability of detecting an effect of a given size if it exists. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Pre-aggregation: a stored summary table used to answer common queries quickly. See [Semantic layer](<https://wiki.4tm0.net/data/semantic-layer.html>).
- Pre-signed URL: a time-limited link that grants read access to one object. See [Data sharing](<https://wiki.4tm0.net/data/data-sharing.html>).
- Predicate pushdown: using a filter to skip data before reading it. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Predicate pushdown (Query performance on lake tables): passing a filter to the table reader so data can be skipped before it is read. See [Query performance on lake tables](<https://wiki.4tm0.net/data/query-performance.html>).
- Prediction log: a record of every prediction with inputs and model version. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Prefix: the start of a key, used for listing and access rules; what consoles show as a folder. See [Object storage and the S3 API](<https://wiki.4tm0.net/data/object-storage.html>).
- Prefix (Naming conventions): a name start that marks a layer or table type, such as clean\_ or fct\_. See [Naming conventions](<https://wiki.4tm0.net/data/naming-conventions.html>).
- Primary and guardrail metrics: what should improve, and what must not get worse. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Probabilistic matching: matching on scored similarity across several fields. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Processing time: when the pipeline handles the event. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Producer: the team that creates and changes the dataset. See [Data contracts](<https://wiki.4tm0.net/data/data-contracts.html>).
- Projection: reading only the columns a query needs. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Projection pushdown: reading only the columns a query uses. See [Query performance on lake tables](<https://wiki.4tm0.net/data/query-performance.html>).
- Promotion: moving a model version to a higher status, such as production, under defined rules. See [The ML lifecycle and MLOps](<https://wiki.4tm0.net/data/ml-lifecycle-mlops.html>).
- Prompt injection: instructions hidden in data that try to steer the model. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- Prompting: guiding a model with instructions and examples in each request. See [Fine-tuning or RAG](<https://wiki.4tm0.net/data/fine-tuning-vs-rag.html>).
- Provider: the party that owns and shares the data. See [Data sharing](<https://wiki.4tm0.net/data/data-sharing.html>).
- Pseudonymisation: replacing identifiers with pseudonyms while the re-identification key is kept apart. See [PII and data classification](<https://wiki.4tm0.net/data/pii-and-classification.html>).
- Puffin file: a file of extra table statistics, such as distinct value estimates, or deletion vectors. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Pull and push: the platform fetches data, or the source sends it. See [Ingestion patterns](<https://wiki.4tm0.net/data/ingestion-patterns.html>).
- Pull request: a proposed change, reviewed and checked before merging. See [Environments and CI](<https://wiki.4tm0.net/data/environments-and-ci.html>).
- PyIceberg: the Python library for reading and writing Iceberg tables. See [Python on the lakehouse](<https://wiki.4tm0.net/data/python-on-the-lakehouse.html>).

## Q

- QoS level: MQTT's delivery guarantee per message: 0, 1 or 2. See [IoT and device data](<https://wiki.4tm0.net/data/iot-and-device-data.html>).
- Query plan: the steps an engine will run, shown by EXPLAIN. See [Query performance on lake tables](<https://wiki.4tm0.net/data/query-performance.html>).
- Query-based CDC: finding changes by querying a change column on a schedule. See [Change data capture](<https://wiki.4tm0.net/data/change-data-capture.html>).

## R

- RACI: a matrix of who is Responsible, Accountable, Consulted and Informed per decision. See [Governance roles](<https://wiki.4tm0.net/data/governance-roles.html>).
- Randomisation unit: what is assigned to a group, such as a user. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Range read: reading only part of an object by byte offsets. See [Object storage and the S3 API](<https://wiki.4tm0.net/data/object-storage.html>).
- Rate limit: the maximum number of API calls a target allows per period. See [Reverse ETL and activation](<https://wiki.4tm0.net/data/reverse-etl-activation.html>).
- Raw layer: the copy of source data kept as delivered, the basis for re-running transformations. See [ETL, ELT and EtLT](<https://wiki.4tm0.net/data/etl-elt-etlt.html>).
- RBAC: permissions granted to roles; users get permissions through roles. See [RBAC and ABAC](<https://wiki.4tm0.net/data/rbac-vs-abac.html>).
- Real-time OLAP: databases that answer aggregate queries in milliseconds on fresh data. See [Low-latency serving stores](<https://wiki.4tm0.net/data/low-latency-serving-stores.html>).
- ReBAC: permissions decided from relationships between users and objects. See [RBAC and ABAC](<https://wiki.4tm0.net/data/rbac-vs-abac.html>).
- Rebuild: recreating a layer from the one below after a logic change or a bug. See [Medallion layers: bronze, silver and gold](<https://wiki.4tm0.net/data/medallion-layers.html>).
- Recipient: the party that reads shared data with its own tools. See [Data sharing](<https://wiki.4tm0.net/data/data-sharing.html>).
- Reconciliation: comparing outputs to find and explain differences. See [Platform migration](<https://wiki.4tm0.net/data/platform-migration.html>).
- Reconciliation test: compares counts or totals across tables or systems. See [Testing data pipelines](<https://wiki.4tm0.net/data/testing-data-pipelines.html>).
- Recovery point objective (RPO): the maximum acceptable data loss, as time. See [Disaster recovery](<https://wiki.4tm0.net/data/disaster-recovery.html>).
- Recovery time objective (RTO): the maximum acceptable time to restore. See [Disaster recovery](<https://wiki.4tm0.net/data/disaster-recovery.html>).
- ref(): a reference to another model, from which dbt builds the dependency graph. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- Regional stack: a full set of storage, catalog and compute for one region. See [Residency and regions](<https://wiki.4tm0.net/data/residency-and-regions.html>).
- Relationship: how tables join, declared once in the layer. See [Semantic layer](<https://wiki.4tm0.net/data/semantic-layer.html>).
- Remote signing: the catalog signing each storage request on the engine's behalf. See [Catalogs](<https://wiki.4tm0.net/data/catalogs.html>).
- Replay: reprocessing data from the raw layer or from a log. See [Backfill and replay](<https://wiki.4tm0.net/data/backfill-and-replay.html>).
- Replication slot: PostgreSQL's record of how far a consumer has read the log. See [Change data capture](<https://wiki.4tm0.net/data/change-data-capture.html>).
- Reprocessing window: the number of recent days a batch job recomputes on each run. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Reproducibility: the ability to rerun an analysis on the same data and code and get the same result. See [The data science workflow](<https://wiki.4tm0.net/data/data-science-workflow.html>).
- Resource group: an engine setting that limits resources for a set of queries. See [Multi-tenancy](<https://wiki.4tm0.net/data/multi-tenancy.html>).
- Resource tagging: labelling cloud resources with owner and purpose. See [Cost and FinOps](<https://wiki.4tm0.net/data/cost-finops.html>).
- Retained message: the last message on a topic, kept by the broker for new subscribers. See [IoT and device data](<https://wiki.4tm0.net/data/iot-and-device-data.html>).
- Retention: how long or how much data a topic keeps. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- Retention period: how long snapshots are kept, which is also how far back time travel reaches. See [Iceberg maintenance](<https://wiki.4tm0.net/data/iceberg-maintenance.html>).
- Retention period (Privacy lifecycle): how long a kind of data is kept, and why. See [Privacy lifecycle](<https://wiki.4tm0.net/data/privacy-lifecycle.html>).
- Retrieval-augmented generation (RAG): answering with a model that is given retrieved documents. See [Embeddings, vector search and RAG](<https://wiki.4tm0.net/data/embeddings-vector-search-rag.html>).
- Retrieval-augmented generation (RAG) (Fine-tuning or RAG): adding retrieved documents to each request. See [Fine-tuning or RAG](<https://wiki.4tm0.net/data/fine-tuning-vs-rag.html>).
- Retry: re-running a failed task automatically after a delay. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- Reverse ETL: syncing platform results into operational tools. See [Reverse ETL and activation](<https://wiki.4tm0.net/data/reverse-etl-activation.html>).
- Rollback: making an earlier snapshot the current state of a table. See [Disaster recovery](<https://wiki.4tm0.net/data/disaster-recovery.html>).
- Row filter: a condition that limits which rows a user sees. See [Row-level security and masking](<https://wiki.4tm0.net/data/row-level-security-masking.html>).
- Row group: a horizontal slice of a file, holding one column chunk per column. See [Columnar files and Parquet](<https://wiki.4tm0.net/data/columnar-files-parquet.html>).
- Row-oriented storage: all columns of a row stored together. See [OLTP vs OLAP](<https://wiki.4tm0.net/data/oltp-vs-olap.html>).
- Run parameter: the period a run processes, passed in instead of taken from the clock. See [Backfill and replay](<https://wiki.4tm0.net/data/backfill-and-replay.html>).
- Runbook: written steps for responding to an alert. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).

## S

- Sample ratio mismatch (SRM): a difference between planned and actual group sizes that signals a bug. See [Experimentation and A/B testing](<https://wiki.4tm0.net/data/experimentation-ab-testing.html>).
- Sandbox schema: a personal or project area for experimental tables. See [The data science workflow](<https://wiki.4tm0.net/data/data-science-workflow.html>).
- Satellite: a table of descriptive attributes and their history, attached to a hub or link. See [Other modelling approaches: Data Vault, one big table and activity schema](<https://wiki.4tm0.net/data/other-modelling-approaches.html>).
- Scan: reading a large part of a table rather than looking up single rows. See [OLTP vs OLAP](<https://wiki.4tm0.net/data/oltp-vs-olap.html>).
- Scheduler: the component that starts runs and launches tasks when ready. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- Schema: the declared names, types and constraints of a table's columns. See [Schema-on-write and schema-on-read](<https://wiki.4tm0.net/data/schema-on-write-vs-read.html>).
- Schema drift: unannounced changes in the structure of source data. See [Schema-on-write and schema-on-read](<https://wiki.4tm0.net/data/schema-on-write-vs-read.html>).
- Schema enforcement: rejecting writes that do not match the schema. See [Schema-on-write and schema-on-read](<https://wiki.4tm0.net/data/schema-on-write-vs-read.html>).
- Schema registry: a service that stores schema versions and checks compatibility. See [Schema evolution](<https://wiki.4tm0.net/data/schema-evolution.html>).
- Schema test: checks columns, types and constraints. See [Testing data pipelines](<https://wiki.4tm0.net/data/testing-data-pipelines.html>).
- Secrets manager: a service that stores and distributes credentials securely. See [Encryption and key management](<https://wiki.4tm0.net/data/encryption-and-key-management.html>).
- Self-serve platform: shared infrastructure that lets teams build and publish products on their own. See [Data products and data mesh](<https://wiki.4tm0.net/data/data-products-and-mesh.html>).
- Self-service analytics: users exploring governed data on their own. See [BI and dashboards](<https://wiki.4tm0.net/data/bi-and-dashboards.html>).
- Semi-structured data: records with structure that may vary, such as JSON. See [Schema-on-write and schema-on-read](<https://wiki.4tm0.net/data/schema-on-write-vs-read.html>).
- Sensor: a task that waits for a condition before downstream tasks start. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- Separation of storage and compute: data stored once, processed by engines that can be scaled or swapped independently. See [Data lake, warehouse and lakehouse](<https://wiki.4tm0.net/data/lake-warehouse-lakehouse.html>).
- Sequence number: the order of commits, used to decide which deletes apply to which files. See [Iceberg internals: manifests and planning](<https://wiki.4tm0.net/data/iceberg-internals.html>).
- Service account: an identity for a non-human client. See [Authentication and authorization: OIDC and JWT](<https://wiki.4tm0.net/data/authn-vs-authz-oidc-jwt.html>).
- Service level: a promise about availability, such as data ready by 07:00. See [Data contracts](<https://wiki.4tm0.net/data/data-contracts.html>).
- Service level agreement (SLA): a promise to customers, with consequences if broken. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).
- Service level indicator (SLI): the measured quantity, such as completion time. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).
- Service level objective (SLO): a target for an SLI over a period, such as 98% of days. See [Observability and SLOs](<https://wiki.4tm0.net/data/observability-and-slos.html>).
- Serving store: a database optimised for fast application queries, fed by the platform. See [Data APIs and the backend-for-frontend pattern](<https://wiki.4tm0.net/data/data-api-and-bff.html>), [Low-latency serving stores](<https://wiki.4tm0.net/data/low-latency-serving-stores.html>).
- Shadow deployment: running a new model on live traffic without using its predictions. See [Model serving and monitoring](<https://wiki.4tm0.net/data/model-serving-monitoring.html>).
- Share: a named set of tables or views made available to a recipient. See [Data sharing](<https://wiki.4tm0.net/data/data-sharing.html>).
- Sharing protocol: an open API for discovering and reading shared tables. See [Data sharing](<https://wiki.4tm0.net/data/data-sharing.html>).
- Showback and chargeback: reporting cost to teams, or billing it to their budgets. See [Cost and FinOps](<https://wiki.4tm0.net/data/cost-finops.html>).
- SIEM: a system that collects security logs and detects suspicious patterns. See [Audit logging](<https://wiki.4tm0.net/data/audit-logging.html>).
- Silver (clean): typed, deduplicated, conformed entities. See [Medallion layers: bronze, silver and gold](<https://wiki.4tm0.net/data/medallion-layers.html>).
- Sink connector: a Kafka Connect component that writes topic records to an outside system. See [Writing to Iceberg from Kafka](<https://wiki.4tm0.net/data/kafka-to-iceberg.html>).
- Slim CI: building only changed models and their dependants, reusing production for the rest. See [Environments and CI](<https://wiki.4tm0.net/data/environments-and-ci.html>).
- Slowly changing dimension: a dimension whose attributes change over time. See [History and slowly changing dimensions](<https://wiki.4tm0.net/data/history-and-scd.html>).
- Snapshot: the state of the table after one commit. See [Apache Iceberg: table format basics](<https://wiki.4tm0.net/data/iceberg-table-format-basics.html>).
- Snapshot (Change data capture): the initial read of a table's current rows before streaming changes (not an Iceberg snapshot). See [Change data capture](<https://wiki.4tm0.net/data/change-data-capture.html>).
- Snapshot expiry: removing old snapshots and the files only they referenced. See [Iceberg maintenance](<https://wiki.4tm0.net/data/iceberg-maintenance.html>).
- Snapshot table: a full copy of a table per day or period. See [History and slowly changing dimensions](<https://wiki.4tm0.net/data/history-and-scd.html>).
- Soft delete: marking a row as deleted instead of removing it; it keeps the stored sequence, so a replay cannot bring a deleted row back. See [Deduplication and merge](<https://wiki.4tm0.net/data/deduplication-and-merge.html>).
- Source: a raw table loaded outside dbt, declared so models can reference it. See [dbt](<https://wiki.4tm0.net/data/dbt.html>).
- Source of truth: the system whose data is authoritative when copies disagree. See [Low-latency serving stores](<https://wiki.4tm0.net/data/low-latency-serving-stores.html>).
- Source sequence: an ordering from the source, such as a log position or offset. See [Deduplication and merge](<https://wiki.4tm0.net/data/deduplication-and-merge.html>).
- Star schema: a fact table joined directly to its dimensions. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- State: what a stream processor remembers between events, such as running totals. See [Processing patterns: batch, micro-batch and streaming](<https://wiki.4tm0.net/data/processing-patterns.html>).
- State (Infrastructure as code): the tool's record mapping declarations to real resources. See [Infrastructure as code](<https://wiki.4tm0.net/data/infrastructure-as-code.html>).
- State (Stream processing): data a job keeps between events, partitioned by key. See [Stream processing](<https://wiki.4tm0.net/data/stream-processing.html>).
- Storage limitation: the principle of keeping personal data no longer than needed. See [Privacy lifecycle](<https://wiki.4tm0.net/data/privacy-lifecycle.html>).
- Stream processor: an engine that runs continuous jobs over event streams. See [Stream processing](<https://wiki.4tm0.net/data/stream-processing.html>).
- Stream-table join: enriching events with the current version of a table held in state. See [Stream processing](<https://wiki.4tm0.net/data/stream-processing.html>).
- Subject: the business object an event is about. See [Event design](<https://wiki.4tm0.net/data/event-design.html>).
- Suffix: a name end that marks a type or meaning, such as `_at` or `_key`. See [Naming conventions](<https://wiki.4tm0.net/data/naming-conventions.html>).
- Suppression list: IDs of erased people, used to block reintroduction. See [Privacy lifecycle](<https://wiki.4tm0.net/data/privacy-lifecycle.html>).
- Surrogate key: a key created in the warehouse to identify a dimension row. See [Dimensional modelling](<https://wiki.4tm0.net/data/dimensional-modeling.html>).
- Survivorship: per-attribute rules for which source value wins. See [Multi-source conformance](<https://wiki.4tm0.net/data/multi-source-conformance.html>).
- Sync: a configured transfer from a source model to a destination object. See [Reverse ETL and activation](<https://wiki.4tm0.net/data/reverse-etl-activation.html>).
- Synthetic data: generated data that imitates real data. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).

## T

- Table statistics: row counts and distinct value estimates used by the optimizer. See [Query performance on lake tables](<https://wiki.4tm0.net/data/query-performance.html>).
- Tag: a named reference to one snapshot, with its own retention. See [Write-audit-publish](<https://wiki.4tm0.net/data/write-audit-publish.html>).
- Target: the configuration that decides where and how a run writes. See [Environments and CI](<https://wiki.4tm0.net/data/environments-and-ci.html>).
- Task: one unit of work, such as running a model or loading a file. See [Orchestration](<https://wiki.4tm0.net/data/orchestration.html>).
- Technical catalog: maps table names to current metadata and coordinates commits. See [Catalogs](<https://wiki.4tm0.net/data/catalogs.html>).
- Technical metadata: structure, such as tables, columns and types. See [Catalog and lineage](<https://wiki.4tm0.net/data/catalog-and-lineage.html>).
- Telemetry: periodic measurements sent by devices. See [IoT and device data](<https://wiki.4tm0.net/data/iot-and-device-data.html>).
- Tenant: a customer or organisation whose data must be kept separate. See [Multi-tenancy](<https://wiki.4tm0.net/data/multi-tenancy.html>).
- Tenant key: the column identifying which tenant a row belongs to. See [Multi-tenancy](<https://wiki.4tm0.net/data/multi-tenancy.html>).
- Test fixture: the fixed input rows used by a unit test. See [Testing data pipelines](<https://wiki.4tm0.net/data/testing-data-pipelines.html>).
- Tie-breaker: an extra ordering column that makes the choice deterministic. See [Deduplication and merge](<https://wiki.4tm0.net/data/deduplication-and-merge.html>).
- Time-based split: splitting by date so the model is tested on later data than it learned from. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).
- Timeline: Hudi's record of actions on a table. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).
- Timeliness (freshness): availability by the time it is needed. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Tokenisation: replacing a sensitive value with a token that can be reversed only by a separate, protected service. See [Row-level security and masking](<https://wiki.4tm0.net/data/row-level-security-masking.html>).
- Tombstone: a record with a key and no value, marking a deleted key. See [Change data capture](<https://wiki.4tm0.net/data/change-data-capture.html>).
- Tool: a function an agent can call, described by name, purpose and input schema. See [Agents and MCP](<https://wiki.4tm0.net/data/agents-and-mcp.html>).
- Topic: a named stream of records. See [Kafka and Kafka Connect](<https://wiki.4tm0.net/data/kafka-and-connect.html>).
- Topic hierarchy: slash-separated topic names that can be matched with + and \# wildcards. See [IoT and device data](<https://wiki.4tm0.net/data/iot-and-device-data.html>).
- Trace: the full record of one request through an LLM application. See [LLM applications and evaluation](<https://wiki.4tm0.net/data/llm-applications-evaluation.html>).
- Training run: one execution of training on a specific data version, code version and settings. See [The ML lifecycle and MLOps](<https://wiki.4tm0.net/data/ml-lifecycle-mlops.html>).
- Training, validation and test sets: data for learning, for tuning, and for final evaluation. See [Training data management](<https://wiki.4tm0.net/data/training-data-management.html>).
- Training-serving skew: a difference between features at training and at prediction time. See [Feature engineering and feature stores](<https://wiki.4tm0.net/data/feature-engineering-feature-stores.html>).
- Transaction: a group of reads and writes that succeeds or fails as a whole. See [OLTP vs OLAP](<https://wiki.4tm0.net/data/oltp-vs-olap.html>).
- Transaction log: Delta Lake's ordered record of commits. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).
- Transcription: converting speech to text. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- Transform: cleaning, combining and reshaping data for use. See [ETL, ELT and EtLT](<https://wiki.4tm0.net/data/etl-elt-etlt.html>).
- Type 1: overwrite; no history. See [History and slowly changing dimensions](<https://wiki.4tm0.net/data/history-and-scd.html>).
- Type 2: one row per version, with validity dates. See [History and slowly changing dimensions](<https://wiki.4tm0.net/data/history-and-scd.html>).

## U

- Unbounded data: a stream with no end. See [Processing patterns: batch, micro-batch and streaming](<https://wiki.4tm0.net/data/processing-patterns.html>).
- UniForm: Delta Lake's feature that also writes Iceberg-compatible metadata. See [Table formats compared: Iceberg, Delta Lake, Hudi and Paimon](<https://wiki.4tm0.net/data/table-format-comparison.html>).
- Uniqueness: no duplicate entities. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Unit cost: cost per unit of value, such as per dashboard view or per million orders processed. See [Cost and FinOps](<https://wiki.4tm0.net/data/cost-finops.html>).
- Unit test: runs logic on fixed inputs and compares with expected output. See [Testing data pipelines](<https://wiki.4tm0.net/data/testing-data-pipelines.html>).
- Unstructured data: content without a fixed tabular structure, such as documents, images and audio. See [Unstructured and multimodal data](<https://wiki.4tm0.net/data/unstructured-multimodal-data.html>).
- Upsert mode: records replace or delete existing rows by key. See [Writing to Iceberg from Kafka](<https://wiki.4tm0.net/data/kafka-to-iceberg.html>).

## V

- Validity: conformance to type, format and allowed values. See [Data quality dimensions](<https://wiki.4tm0.net/data/data-quality-dimensions.html>).
- Versioned load: loading a new table version and switching readers to it at once. See [Low-latency serving stores](<https://wiki.4tm0.net/data/low-latency-serving-stores.html>).

## W

- Watermark: the stored position, such as the highest updated\_at loaded, from which the next run continues (not the streaming watermark in [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>)). See [Ingestion patterns](<https://wiki.4tm0.net/data/ingestion-patterns.html>).
- Watermark (streaming): an estimate that no events older than a given time are still to come. See [Late and out-of-order data](<https://wiki.4tm0.net/data/late-and-out-of-order-data.html>).
- Window: a slice of a stream, such as the last five minutes, used to compute results. See [Processing patterns: batch, micro-batch and streaming](<https://wiki.4tm0.net/data/processing-patterns.html>).
- Window (Stream processing): a time-based grouping of events: tumbling, sliding or session. See [Stream processing](<https://wiki.4tm0.net/data/stream-processing.html>).
- Winning record: the record chosen as current for a key. See [Deduplication and merge](<https://wiki.4tm0.net/data/deduplication-and-merge.html>).
- Worker: a process that reads data and executes part of the plan. See [SQL query engines](<https://wiki.4tm0.net/data/sql-query-engines.html>).
- Write-audit-publish (WAP): write unseen, check, then publish atomically. See [Write-audit-publish](<https://wiki.4tm0.net/data/write-audit-publish.html>).
- Write-once storage: storage where records cannot be changed or deleted for a retention period. See [Audit logging](<https://wiki.4tm0.net/data/audit-logging.html>).
