I have generated a decent sized dataset to show Snowflake's Pivot function is underperforming and a different strategy can give us much as a 2x improvement in runtime.
Show HN: Benchmark two strategies for a pivot operation in Snowflake | Heykuki News