Data Reflections course - 5
Date & Time granularity
Dremio gives you control of the granularity of Date & Time values as dimensions in aggregate reflections. This control influences both the behavior and size of the resulting reflection.
By default, Dremio will store the Date & Time value “rolled up” to (D) day granularity
As an option, you can store Date & Time values in (O) original granularity. This will result in a much larger reflection file but may be required when queries use granularities less than a day, such as hours or minutes
The definition of the aggregate reflection will show the selected granularity
Dremio gives you control of the granularity of Date & Time values as dimensions in aggregate reflections. This control influences both the behavior and size of the resulting reflection.
By default, Dremio will store the Date & Time value “rolled up” to (D) day granularity
As an option, you can store Date & Time values in (O) original granularity. This will result in a much larger reflection file but may be required when queries use granularities less than a day, such as hours or minutes
The definition of the aggregate reflection will show the selected granularity