Blogatogg

Paulius Alaburda’s blog posts

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:

Qualifying Events Using Recursive CTEs

SQL

And the joys of writing trash SQL code

Grouping Non-Overlapping Date Ranges

SQL

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…

Finding Gaps in Sequences

SQL

Grouping Overlapping Date Ranges

SQL

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…

The Data Caterer

prose