script to find out table part of the datashare in AWS redshift:
SELECT share_type,
btrim(share_name)::varchar(16) AS share_name,
object_type,
object_name
FROM svv_datashare_objects
WHERE share_name='<share_name>'
AND object_name LIKE '%<table_name>%'
ORDER BY object_name;
No comments:
Post a Comment