Zero-ETL integration event notifications with Amazon EventBridge - Amazon Redshift
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).

Zero-ETL integration event notifications with Amazon EventBridge

Zero-ETL integration uses Amazon EventBridge to manage event notifications to keep you up-to-date regarding changes in your integrations. Amazon EventBridge is a serverless event bus service that you can use to connect your applications with data from a variety of sources. In this case, the event source is Amazon Redshift. Events, which are monitored changes in an environment, are sent to EventBridge from your Amazon Redshift data warehouse automatically. Events are delivered in near real time.

EventBridge provides an environment for you to write event rules, which can specify actions to take for specific events. You can also set up targets, which are resources that EventBridge can send an event to. A target can include an API destination, an Amazon CloudWatch log group, and others. For more information about rules, see Amazon EventBridge rules. For more information about targets, see Amazon EventBridge targets.

Events can be classified into severities and categories. The following filters are available:

  • Resource filtering – Receive messages based on the resource that the events are associated with. Resources include a workgroup or a snapshot.

  • Time window filtering – Scope events in a specific time period.

  • Category filtering – Receive event notifications for all events in specified categories.

The following table includes zero-ETL integration events, with additional metadata:

Amazon Redshift Category External Event ID Event Severity Message Description

Monitoring

REDSHIFT-INTEGRATION-EVENT-0000 INFO Zero-ETL integration <integration name> has been created and is now ACTIVE.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0001 INFO Zero-ETL integration <integration name> was deleted at <time in UTC>.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0002 INFO Initiated deletion of zero-ETL integration <integration name> at <time in UTC>.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0003 INFO Zero-ETL integration <integration name> is syncing transactional data to the target data warehouse.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0004 WARNING One or more tables doesn't have a primary key and can't be synchronized. Take a backup on Amazon RDS, drop these tables, and recreate them following the Amazon Redshift best practices for designing tables.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0005 WARNING One or more tables can't be synchronized because they contain unsupported data types or lengths. Fix the tables and try again. For unsupported data types, see Unsupported data types.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0006 ERROR Unable to create integration. Delete and recreate the integration.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0007 ERROR Unable to load data due to an internal failure. Delete and recreate the integration.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0008 ERROR Authorization failed because permissions have been revoked from the source Aurora DB cluster DB cluster. Delete and recreate the integration.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0009 ERROR Unable to send data to Amazon Redshift because the number of tables and schemas exceed the Amazon Redshift limit. Delete and recreate the integration.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0012 ERROR A restore from recovery point was invoked on the destination serverless namespace. Delete and recreate the integration.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0013 INFO Zero-ETL integration <integration name> is now ACTIVE.

Monitoring

REDSHIFT-INTEGRATION-EVENT-0014 ERROR Integration <integration name> failed because it could not be modified due to an internal error. Delete and recreate the integration. If the error persists, contact Amazon Support.
Operation REDSHIFT-INTEGRATION-EVENT-0015 INFO A DDL change <DDL Change> has been applied to table <schema.name>.
Operation REDSHIFT-INTEGRATION-EVENT-0016 INFO Your zero-ETL integration <integration name> is processing a modification request with the following arguments: <copy of request arguments>.
Operation REDSHIFT-INTEGRATION-EVENT-0017 INFO Your modification to zero-ETL integration <integration name> has been applied.
Operation REDSHIFT-INTEGRATION-EVENT-0018 WARNING Target Amazon Redshift cluster is being paused. Wait for the cluster to be paused and then resume it to continue streaming data.

Operation

REDSHIFT-INTEGRATION-EVENT-0019 WARNING Target Amazon Redshift cluster is being paused. Resume the cluster to continue streaming data.
Operation REDSHIFT-INTEGRATION-EVENT-0020 WARNING Target Amazon Redshift cluster is being resumed. Wait for the cluster to be active to continue streaming data.
Configuration REDSHIFT-INTEGRATION-EVENT-1000 ERROR One or more parameters on the source Aurora DB cluster DB cluster are misconfigured. Fix the parameter group and reboot the cluster to apply the changes, then recreate the integration.
Configuration REDSHIFT-INTEGRATION-EVENT-1001 ERROR Integration failed because the value of the enable_case_sensitive_identifier parameter is incorrect. Set the value to true for the source Aurora DB cluster DB cluster, then delete and recreate the integration.
Configuration REDSHIFT-INTEGRATION-EVENT-1002 ERROR Integration failed because the value of the cdc_insert_enabled parameter is incorrect. Set the value to true for the source Aurora DB cluster DB cluster, then delete and recreate the integration.
Configuration REDSHIFT-INTEGRATION-EVENT-1003 ERROR

The binlog_format parameter in the source DB cluster parameter group must be set to ROW. Fix the parameter group and reboot the cluster to apply the change, then recreate the integration.

Configuration REDSHIFT-INTEGRATION-EVENT-1004 ERROR

Unable to load data because the binlog_transaction_compression cluster parameter is enabled. Set the parameter value to OFF and reboot the writer instance to apply the change, then recreate the integration.

Configuration REDSHIFT-INTEGRATION-EVENT-1005 ERROR

Unable to load data because the binlog_row_value_options cluster parameter is set to PARTIAL_JSON, which is not supported. Fix the parameter group and reboot the writer instance to apply the change, then recreate the integration.

Configuration

REDSHIFT-INTEGRATION-EVENT-1006 WARNING

Unable to parse integration filter. Fix the filter syntax.