Inferensys

Glossary

Feature Table

A database table in the offline or online store that physically stores the values for a specific feature group, keyed by entity and timestamp.
Data engineer managing feature store on laptop, feature definitions visible, casual data engineering session.
DEFINITION

What is a Feature Table?

A feature table is the physical storage component within a feature store that persists the actual values for a specific feature group, organized by entity and timestamp.

A Feature Table is a database table in the offline or online store that physically stores the values for a specific feature group, keyed by entity and timestamp. It serves as the materialized storage layer, holding the pre-computed numerical or categorical values that are retrieved during training data generation or low-latency model inference.

Each row in a feature table represents a feature vector slice for a single entity at a specific point in time, enabling point-in-time correctness during training. The table's schema is governed by the feature registry, and its data is populated through the materialization process, which transforms raw source data into the consistent, serving-ready format required by machine learning models.

ANATOMY

Key Characteristics of a Feature Table

A feature table is the physical storage primitive within a feature store, organizing feature values by entity and timestamp for consistent retrieval during training and inference.

01

Entity-Based Primary Key

Every row in a feature table is uniquely identified by an entity ID (e.g., user_id, product_sku) and a timestamp. This composite key ensures that feature values are correctly joined to the right business object at the right point in time. Without this structure, models would ingest misaligned data, leading to incorrect predictions.

02

Temporal Versioning

Feature tables maintain a full history of values through time-series rows. Each update to a feature inserts a new row with a new timestamp rather than overwriting the old value. This enables point-in-time correct training dataset generation, where you can reconstruct the exact feature state as it existed historically, preventing data leakage from the future.

03

Schema Enforcement

Feature tables enforce a strict schema defining column names, data types, and constraints. This contract is typically registered in the Feature Registry and validated on every write. Common types include:

  • Numerical: FLOAT, INT64 for counts and ratios
  • Categorical: STRING or BYTES for one-hot encoding
  • Embedding: ARRAY<FLOAT> for dense vector representations
04

Online vs. Offline Physical Layout

The same logical feature table is materialized differently depending on the store:

  • Offline Store: Columnar formats like Parquet optimized for high-throughput batch scans during training
  • Online Store: Row-oriented key-value stores like Redis or DynamoDB optimized for single-entity, low-latency lookups at inference time This dual physical layout is a core architectural pattern of feature stores.
05

Feature Group Affiliation

A feature table belongs to a Feature Group, which bundles related features sharing the same source, entity, and update cadence. For example, a user_demographics group might contain age, income_bracket, and location_city columns. This grouping simplifies management, backfilling, and monitoring of features that logically belong together.

06

Freshness and Staleness Metadata

Each feature table carries metadata defining its maximum staleness—the acceptable age of a value before it is considered unreliable. A real-time feature like items_in_cart might require sub-second freshness, while a batch feature like lifetime_purchase_total can tolerate a 24-hour lag. This metadata drives monitoring alerts and materialization schedules.

FEATURE TABLE CLARIFICATIONS

Frequently Asked Questions

Clear answers to common questions about the structure, purpose, and operational mechanics of feature tables within a feature store.

A feature table is a database table that physically stores the values for a specific feature group, keyed by an entity and a timestamp. It serves as the materialized storage layer within a feature store, bridging the gap between raw data engineering and model consumption. In the offline store, it persists historical feature values for large-scale model training, while in the online store, it holds the latest pre-computed values for low-latency inference. The table's schema is defined by a feature registry, ensuring that each column's type and lineage are strictly governed. When a model requests a feature vector, the serving infrastructure queries the relevant feature tables, joins them on the entity ID, and returns the most recent values based on the specified feature freshness requirements.

Prasad Kumkar

About the author

Prasad Kumkar

CEO & MD, Inference Systems

Prasad Kumkar is the CEO & MD of Inference Systems and writes about AI systems architecture, LLM infrastructure, model serving, evaluation, and production deployment. Over 5+ years, he has worked across computer vision models, L5 autonomous vehicle systems, and LLM research, with a focus on taking complex AI ideas into real-world engineering systems.

His work and writing cover AI systems, large language models, AI agents, multimodal systems, autonomous systems, inference optimization, RAG, evaluation, and production AI engineering.