We have two dimensions that have a parent/child relationship - L0 Company and L1 Parent Company. For the exercise, here are some details:
- L0 has 500,000 items, L1 has 400,000 items
- This property will be upstream of a fairly complex cohorted revenue model
- Both dimensions are provided to us from Snowflake
- The date formatted property “First ARR Date” exists at the L0 Company level
We need First ARR Date in L1 Parent Company in Pigment, what is the preferred way to do this to maximize performance?
- Aggregate from L0 to L1 in Pigment using a BY MIN
- Aggregate in Snowflake & import the First ARR Date into both our L0 and L1 dimensions
- A third option?
Further, would the right way to do this change if the balance of list items between lists changed?