Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the [ blog post ](https://amazonaws-china.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# SYS\_DATASHARE\_USAGE\_PRODUCER
<a name="SYS_DATASHARE_USAGE_PRODUCER"></a>

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](cm_chap_system-tables.md#c_visibility-of-data).

## Table columns
<a name="SYS_DATASHARE_USAGE_PRODUCER-table-rows"></a>


| 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 | varchar(512) | The message for an error. | 
| consumer\_region | char(64) | The Region that the consumer cluster is in. | 

## Sample queries
<a name="SYS_DATASHARE_USAGE_PRODUCER-sample-queries"></a>

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"
```