Special Columns
The following are usage guidelines and considerations for special columns in Kumo tables:
Primary Key Columns
Each row should have a primary key consisting of a unique value (e.g., user ID).
Considerations
- If multiple rows have the same primary key value, only one of the rows will be chosen and the rest will be dropped.
Date/Time Columns
Kumo requires you to select a single time column of "timestamp" type for each fact table.
Considerations
- No de-duplication occurs if identical rows exist in a fact table; Kumo assumes all of them will be used for modeling purposes.
- Fact table rows missing a time column value will be ignored.
Updated 7 months ago