Efficiently applying window recipes across monthly database partitions
Hi all, I’m looking for best practices when applying window recipes that need to span multiple partitions. In my case, I have a dataset partitioned by month, and I’m using a window recipe with lead/lag functions to look ahead and behind by 3 months. To make this work, I currently: Unpartition the dataset using a sync…