SVL_DATASHARE_USAGE_CONSUMER

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

SVL_DATASHARE_USAGE_CONSUMER 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.

Some or all of the data in this table can also be found in the SYS monitoring view SYS_DATASHARE_USAGE_CONSUMER. The data in the SYS monitoring view is formatted to be easier to use and understand. We recommend that you use the SYS monitoring view for your queries.

Table columns

Column name	Data type	Description
userid	integer	The ID of the user issuing the request.
pid	integer	The ID of the leader process running the query.
xid	bigint	The context of the current transaction.
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.
transaction_uid	varchar(50)	The unique ID of the transaction.
recordtime	timestamp	The time when the action is recorded.
status	integer	The status of the requested API call.
error	varchar(512)	The message for an error.

Sample queries

The following example shows a SVL_DATASHARE_USAGE_CONSUMER view.

SELECT request_type, status, trim(error) AS error
FROM svl_datashare_usage_consumer

  request_type  | status | error
----------------+--------+--------
 "GET RELATION" |   0    |