UNPIVOT multiple columns in Snowflake | Query Optimization in Snowflake (QOSF)

Using TRANSFORM function in Snowflake to extract values from a json array | Query Optimization in Snowflake (QOSF)