AI engineering glossary · Data engineering

What is grain?

Grain (also called Granularity): The precise level of detail that one row of a fact table represents, such as one order line or one daily total per store. Declaring it first prevents mixing levels and double counting.

Level: advancedTopic: Data engineering

Grain: an example

A sales fact at order-line grain has one row per product in an order, not one per order.

Related terms

More Data engineering terms

Where you learn it

Grain is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.

Before you go

Take the cheat sheet with you

One free PDF: the key AI-engineering terms, formulas and Python idioms. No spam; unsubscribe any time.