Why you should think twice before UNNESTing arrays or date intervals
If you ever work with terabyte-scale data, try to avoid unnecessary unnesting/unpacking arrays and date ranges. If you have no choice, materialize the unnested result and partition and cluster it accordingly in preparation for any further joins.
With...
datawise.dev3 min read