Redshift Observatory

System Table Tracker

System view pg_catalog.svv_datashare_consumers version 1.0.45698 / 2023-01-27

schema	name	column	data type
pg_catalog	svv_datashare_consumers	consumer_account	varchar(16)
pg_catalog	svv_datashare_consumers	consumer_namespace	varchar(64)
pg_catalog	svv_datashare_consumers	share_date	timestamp
pg_catalog	svv_datashare_consumers	share_name	varchar(128)

View Text

SELECT CAST(pd.sharename AS varchar(128)) AS share_name,
       CAST(CASE
              WHEN pd.flag & CAST(1 AS bigint)
                THEN CAST('ADX' AS name)
              ELSE dsc.consumeraccount
            END AS varchar(16)) AS consumer_account,
       CAST(dsc.consumernamespace AS varchar(64)) AS consumer_namespace,
       dsc.sharedate AS share_date
FROM pg_datashare_consumers AS dsc
     LEFT JOIN pg_datashare AS pd ON pd.oid = dsc.shareid
WHERE has_datashare_privilege(CAST("current_user"() AS name),
                              CAST(pd.sharename AS text))

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