Redshift に import した UDF を確認する。
sample=# select * from pg_library a, pg_language b where a.language_oid = b.oid; name | language_oid | file_store_id | owner | lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl ------------------+--------------+---------------+-------+-----------+---------+--------------+---------------+--------------+----------------- aws_teradata_ext | 201561 | 2000 | 100 | plpythonu | t | f | 201560 | 201559 | {rdsdb=U/rdsdb} (1 row)
ソースを確認する。
sample=# select prosrc from pg_proc where proname = 'weeknumber_of_year'; import td_business_calendar if indata <> '' : return td_business_calendar.WeekNumber_Of_Year(indata,calendar_name) else: raise Exception('Wrong Format')