I came across this site with some cool Snowflake snippets that you might find helpful.

https://sql-snippets.count.co/c/snowflake-snippets/6

This one in particular, to parse the URL, is awesome! Would be great for web analytics use cases:

https://sql-snippets.count.co/t/parse-url/79