sqlbase64decodeamazon-redshift

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 ?

Solution

  • 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