Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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