Also understand how pruning happens in Snowflake, not every parent-key in the satellite will have a high-date in the same micro-partition. In fact it will be scattered meaning the min/max value for each micro-partition based on end-date date will overlap resulting in poor pruning performance and then you're forced to try things like auto-clustering the satellite table and on a 61 million satellite table that will grow that will be very costly