Partition Date filtering on multiple days spills over on certain times

[DillonMorrison]

Meaning, running a query with partition date between 8/2 and 8/5 will give you a different total than individually summing 8/2 + 8/3 + 8/4 + 8/5. This is due to slight spillover of a few minutes (discrepancies under 1%).

Known limitation of using _TABLE_SUFFIX over multiple days with a dynamic filter.