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

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    |