Tuesday, October 8, 2024

script to find out table part of the datashare in AWS redshift

 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