Redshift Observatory

System Table Tracker

System view pg_catalog.sys_datashare_usage_producer version 1.0.70695 / 2024-07-11

schema name column data type
pg_catalog sys_datashare_usage_producer consumer_account varchar(16)
pg_catalog sys_datashare_usage_producer consumer_namespace varchar(64)
pg_catalog sys_datashare_usage_producer consumer_region varchar(64)
pg_catalog sys_datashare_usage_producer consumer_transaction_uid varchar(50)
pg_catalog sys_datashare_usage_producer error varchar(512)
pg_catalog sys_datashare_usage_producer object_name varchar(128)
pg_catalog sys_datashare_usage_producer object_oid int4
pg_catalog sys_datashare_usage_producer object_type varchar(64)
pg_catalog sys_datashare_usage_producer record_time timestamp
pg_catalog sys_datashare_usage_producer request_id varchar(50)
pg_catalog sys_datashare_usage_producer request_type varchar(25)
pg_catalog sys_datashare_usage_producer share_id int4
pg_catalog sys_datashare_usage_producer share_name varchar(128)
pg_catalog sys_datashare_usage_producer status int4

View Text

Error: describing system view <sys_datashare_usage_producer> is disabled.

Note the AWS are as you see here censoring the SQL of more recent system tables views. This is problematic, as the docs are no good, and so it's not uncommon to need to view the text to make sense of the output. I am of the view AWS, at least as far as Redshift are concerned, has a culture of secrecy and I see this as more of the same. I can see absolutely no reason or benefit, for users, for censoring the view 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