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

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