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"