Redshift - python UDF for decoding url strings

RS_decode_url.sql

-- This example decodes percent-encoded sequences from url parameters, 
-- replaces plus signs with spaces, and converts to all lowercase.

CREATE OR REPLACE FUNCTION schema_name.function_name(original TEXT)
    RETURNS VARCHAR IMMUTABLE AS
        $$
        import urllib
        u = urllib.unquote_plus(original)
        return u.lower()
        $$
    LANGUAGE plpythonu;

SELECT schema_name.function_name(original_url)
FROM schema_name.table_name;

Awesome, thanks for your sharing!