as-of is not the same as current9 November 2026·4 minsphilip mathew hernarticle Sql As-Of Slowly-Changing-Dimension Grain Data-Modelinga lot of warehouse bugs come from answering the wrong time question. i explain when you need an as-of result instead of the current row, and three patterns that keep the grain correct.
