CODEWITHSUNDEEP
python-3.xamazon-web-servicesamazon-s3amazon-redshift
Vishal786btc
Vishal786btc

Reputation: 438

AWS Redshift: How to describe a library created in redshift?

I am using python udfs. These udfs using certain python libraries. I have stored the wheels of these libraries in s3. I create those functions to be used from these libraries, so I've created library in redshift using the syntax: 

CREATE [ OR REPLACE ] LIBRARY library_name LANGUAGE plpythonu
FROM
{ 'https://file_url'
| 's3://bucketname/file_name'
authorization
  [ REGION [AS] 'aws_region']
}

Can please help on how can I describe the definitions of this library incase if I have to validate if the wheel is the latest one or not?

Upvotes: 2

Views: 529

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 270154

From PG_LIBRARY - Amazon Redshift:

Stores information about user-defined libraries

select * from pg_library;

name       | language_oid | file_store_id | owner
-----------+--------------+---------------+------
f_urlparse |       108254 |          2000 |   100

Upvotes: 2

Related Questions