Redshift Observatory

System Table Tracker

System view pg_catalog.svv_datashare_objects version 1.0.52931 / 2023-07-07

View Text

SELECT 'OUTBOUND' AS share_type,
       CAST(outbound_objects.share_name AS varchar(128)) AS share_name,
       CAST(outbound_objects.object_type AS varchar(64)) AS object_type,
       CAST(outbound_objects.object_name AS varchar(512)) AS object_name,
       CAST(outbound_objects.producer_account AS varchar(16)) AS producer_account,
       CAST(outbound_objects.producer_namespace AS varchar(64)) AS producer_namespace,
       CASE
         WHEN CAST(outbound_objects.object_type AS text) = CAST('schema' AS text)
           THEN outbound_objects.include_new
         ELSE CAST(NULL AS boolean)
       END AS include_new
FROM pg_get_outbound_datashare_objects() AS outbound_objects(share_name varchar,
                                                             object_type varchar,
                                                             object_name varchar,
                                                             producer_account varchar,
                                                             producer_namespace varchar,
                                                             include_new boolean)

UNION ALL

SELECT 'INBOUND' AS share_type,
       CAST(incoming_objects.share_name AS varchar(128)) AS share_name,
       CAST(incoming_objects.object_type AS varchar(64)) AS object_type,
       CAST(incoming_objects.object_name AS varchar(512)) AS object_name,
       CAST(incoming_objects.producer_account AS varchar(16)) AS producer_account,
       CAST(incoming_objects.producer_namespace AS varchar(64)) AS producer_namespace,
       CAST(NULL AS unknown) AS include_new
FROM pg_get_inbound_datashare_objects() AS incoming_objects(share_name varchar,
                                                            object_type varchar,
                                                            object_name varchar,
                                                            producer_account varchar,
                                                            producer_namespace varchar)

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers