Blog

Grouping Overlapping Date Ranges

It’s pretty straightforward to group rows in SQL if their date ranges are consecutive or have fixed gaps.¹ It’s much harder if you want to group overlapping date ranges. I…

Paulius Alaburda

Grouping Non-Overlapping Date Ranges

If you’re a data analyst at a company, it’s VERY likely your company stores some data as a Type 2 slowly-changing dimension. It’s also likely that the way it’s stored may…

Paulius Alaburda

dbt docs runs queries with pivot macros?

I can’t for the life of me find this documented but apparently queries that use the pivot or unpivot macros are run so that their compiled code becomes available in the…

dbt anti-pattern: using {{ this }} directly in incremental refreshes

If you’re using dbt, the recommended default way to build incremental models looks like this: