Realize this macro was written for BigQuery, and many of the functions in BQ are different from Snowflake so don't work there. It's a very useful macro tho, so I ported it to SnowflakeSQL for my own use. Would be happy to contribute that back to the project. My question would be how you'd like to implement that. As sub-macros that are platform specific (BQ & Snowflake) with the original macro calling the the subs based on a new param that defaults to BQ. Or just a separate, snowflake-specific macro and leave the old BQ version as is.
Realize this macro was written for BigQuery, and many of the functions in BQ are different from Snowflake so don't work there. It's a very useful macro tho, so I ported it to SnowflakeSQL for my own use. Would be happy to contribute that back to the project. My question would be how you'd like to implement that. As sub-macros that are platform specific (BQ & Snowflake) with the original macro calling the the subs based on a new param that defaults to BQ. Or just a separate, snowflake-specific macro and leave the old BQ version as is.