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.