Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, 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/). 

# SYS\$1INTEGRATION\$1TABLE\$1ACTIVITY
<a name="r_SYS_INTEGRATION_TABLE_ACTIVITY"></a>

SYS\$1INTEGRATION\$1TABLE\$1ACTIVITY displays details of insert, delete, and update activity of zero-ETL integrations. There is one row added for each completed ingestion.

A superuser can see all rows in this table.

For more information, see [zero-ETL integrations](https://docs.amazonaws.cn//redshift/latest/mgmt/zero-etl-using.html).

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

[\[See the AWS documentation website for more details\]](http://docs.amazonaws.cn/en_us/redshift/latest/dg/r_SYS_INTEGRATION_TABLE_ACTIVITY.html)

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

The following SQL command displays activity of the integration. 

```
select * from sys_integration_table_activity;

          integration_id              | checkpoint_name | target_database | schema_name |     table_name    | table_id     | record_time                | transaction_id  | inserted_rows  | deleted_rows | updated_rows | bytes_ingested 
--------------------------------------+-----------------+-----------------+-------------+-------------------+--------------+----------------------------+-----------------+----------------+--------------+--------------+---------------
 4798e675-8f9f-4686-b05f-92c538e19629 |                 | sample_test2    |    sample   | SampleTestChannel |  111276      | 2023-05-12 12:40:30.656625 | 7736            |  2             | 0            | 0            | 125
```