In this example:
Q1. It is shown to use of Hour and minutes as well in the dim_dates. How it will be used? A foreign key uses the date as a value then what will be the value of the hour and minutes in that?
Q2. We can generate this kind of value with interval property and then use of extract?
Any one can provide the example for the same?
Hello @hardikg,
I think an example is to create sliding window queries that allow for overlapping time Intervals. You used them with Watermarks in streaming queries in the last week of Course3.
Note if your Interval contains month or years there is no defined way of how many hours there are since the days in a month or year may vary.