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.