Modifying Aurora zero-ETL integrations with Amazon Redshift - Amazon Aurora
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).

Modifying Aurora zero-ETL integrations with Amazon Redshift

You can modify only the name, description, and data filtering options for a zero-ETL integration with Amazon Redshift. You can't modify the Amazon KMS key used to encrypt the integration, or the source or target databases.

If you add a data filter to an existing integration, Aurora reevaluates the filter as if it always existed. It removes any data that is currently in the target Amazon Redshift data warehouse that doesn't match the new filtering criteria. If you remove a data filter from an integration, it replicates any data that previously didn't match the filtering criteria (but now does) into the target data warehouse. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift.

You can modify a zero-ETL integration using the Amazon Web Services Management Console, the Amazon CLI, or the Amazon RDS API.

Note

Currently, you can only modify integrations that have Aurora MySQL source DB clusters. Modifying integrations isn't supported for the preview release of Aurora PostgreSQL zero-ETL integrations with Amazon Redshift.

To modify a zero-ETL integration

  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Zero-ETL integrations, and then choose the integration that you want to modify.

  3. Choose Modify and make modifications to any available settings.

  4. When all the changes are as you want them, choose Modify.

To modify a zero-ETL integration using the Amazon CLI, call the modify-integration command. Along with the --integration-identifier, specify any of the following options:

The following request modifies an existing integration.

For Linux, macOS, or Unix:

aws rds modify-integration \
    --integration-identifier ee605691-6c47-48e8-8622-83f99b1af374 \
    --integration-name my-renamed-integration

For Windows:

aws rds modify-integration ^
    --integration-identifier ee605691-6c47-48e8-8622-83f99b1af374 ^
    --integration-name my-renamed-integration

To modify a zero-ETL integration using the RDS API, call the ModifyIntegration operation. Specify the integration identifier, and the parameters that you want to modify.