How to convert a string into a url-friendly string in Snowflake SQL?

Question

I am working in Snowflake and have a column pets that I'm trying to put into a url friendly format so they can be concatenated to links within Metabase. Example:

'Tom & Jerry' -> 'Tom%20%26%20Jerry'

Is there a function in Snowflake that does this?

Simeon Pilgrim · Accepted Answer · 2022-05-07 01:36:20Z

1

I don't think there is one. But Javascript has sush a thing, so we can wrap that into a function:

create function urlencodestring(str string)
returns string
language javascript
strict
as
'
    return encodeURIComponent(STR);
';

then go crazy:

select urlencodestring('Tom & Jerry');

URLENCODESTRING('TOM & JERRY')
Tom%20%26%20Jerry

answered May 7, 2022 at 1:36

Simeon Pilgrim

26.7k3 gold badges38 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert a string into a url-friendly string in Snowflake SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related