Re:Things I wished more developers knew about databases
by JamesSwift on Wednesday April 22, 2020 @12:35PM
(#22947393)
Yes, the time table is a pregenerated set of all possible moments in time for whatever resolution you care about. So, for example, if you cared about day resolution it might be
You would FK on the `date_key` and add as many columns as you need to support querying against the dimension. I also like to add a proper `datetime` representation of the date so I can easily do a date range query.
[ Parent
| on HN ]
There are no comments on this comment yet.