SYS_DATASHARE_USAGE_PRODUCER - Amazon Redshift
Table columnsSample queries
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SYS_DATASHARE_USAGE_PRODUCER

Records the activity and usage of datashares. This view is only relevant on the producer cluster.

SYS_DATASHARE_USAGE_PRODUCER is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
share_id integer The object ID (OID) of the datashare.
share_name varchar(128) The name of the datashare.
request_id varchar(50) The unique ID of the requested API call.
request_type varchar(25) The type of the request made to the producer cluster.
object_type varchar(64) The type of the object being shared from the datashare. Possible values are schemas, tables, columns, functions, and views.
object_oid integer The ID of the object being shared from the datashare.
object_name varchar(128) The name of the object being shared from the datashare.
consumer_account varchar(16) The account of the consumer account that the datashare is shared to.
consumer_namespace varchar(64) The namespace of the consumer account that the datashare is shared to.
consumer_transaction_uid varchar(50) The unique transaction ID of the statement on the consumer cluster.
record_time timestamp The time when the action is recorded.
status integer The status of the datashare.
error_message varchar(512) The message for an error.
consumer_region char(64) The Region that the consumer cluster is in.

Sample queries

The following example shows the SYS_DATASHARE_USAGE_PRODUCER view.

SELECT DISTINCT 
FROM sys_datashare_usage_producer 
WHERE object_name LIKE 'tickit%';
   
   request_type
 ------------------   
   "GET RELATION"