Base64 decode in redshift

Is there a redshift/sql function to decode a base64 string ? If not please suggest me how to write a function in redshift to decode base64 ?

2 Answers

Thanks for the great suggestion. It worked. Here is my function. Only issue is that to create a function you have to be a superuser.

create function f_base64decode (a varchar) returns varchar stable as $$ import base64 return base64.b64decode(a) $$ language plpythonu; 

We could check whether the programming language is trusted or not by querying the pg_language table. If it's not trusted, the lanpltrusted is FALSE

SELECT lanpltrusted FROM pg_language WHERE lanname LIKE 'plpythonu'; 

See this http://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_FUNCTION.html, You can create a function in Redshift, and you can use python to code it.

Here are some possible ways to do it in python Python base64 data decode

ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJoa2pwYmiBdYGOm5isnWZpeqWxwqibnmWZo3qzscOsn6KepA%3D%3D