SYS_INTEGRATION_ACTIVITY - Amazon Redshift
Table columnsSample queries

Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post .

SYS_INTEGRATION_ACTIVITY

SYS_INTEGRATION_ACTIVITY displays details about completed integration runs.

SYS_INTEGRATION_ACTIVITY is visible only to superusers. For more information, see Visibility of data in system tables and views.

For information about zero-ETL integrations, see Working with zero-ETL integrations in the Amazon Redshift Management Guide.

Table columns

Column name Data type Description
integration_id character(128) The identifier associated with the integration.
target_database character(128) The database in Amazon Redshift that receives the integration data.
source character(128) The source data for the integration. Possible types includes MySQL and PostgreSQL.
checkpoint_name character(128) The name of the checkpoint replicating binlog coordinates.
checkpoint_type character(16) The type of checkpoint. Possible values include: snapshot, cdc.
checkpoint_bytes bigint The number of bytes in this checkpoint.
last_commit_timestamp timestamp The timestamp when last commited in this checkpoint.
modified_tables integer The number of tables modified in the checkpoint.
integration_start_time time The time (UTC) when integration started for this checkpoint.
integration_end_time time The time (UTC) when integration ended for this checkpoint.

Sample queries

The following SQL command displays the log of integrations. 

select * from sys_integration_activity;

          integration_id              | target_database | source |            checkpoint_name                  | checkpoint_type  | checkpoint_bytes | last_commit_timestamp   | modified_tables |   integration_start_time   |    integration_end_time
--------------------------------------+-----------------+--------+---------------------------------------------+------------------+------------------+-------------------------+-----------------+----------------------------+----------------------------
 76b15917-afae-4447-b7fd-08e2a5acce7b |   demo1         | MySQL  | checkpoints/checkpoint_3_241_3_510.json     |        cdc       |        762       | 2023-05-10 23:00:14.201 |         1       | 2023-05-10 23:00:45.054265 | 2023-05-10 23:00:46.339826
 76b15917-afae-4447-b7fd-08e2a5acce7b |   demo1         | MySQL  | checkpoints/checkpoint_3_16329_3_17839.json |        cdc       |       13488      | 2023-05-11 01:33:57.411 |         2       | 2023-05-11 02:19:09.440121 | 2023-05-11 02:19:16.090492
 76b15917-afae-4447-b7fd-08e2a5acce7b |   demo1         | MySQL  | checkpoints/checkpoint_3_5103_3_5532.json   |        cdc       |        1657      | 2023-05-10 23:13:14.205 |         2       | 2023-05-10 23:13:23.545487 | 2023-05-10 23:13:25.652144