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 AWS 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 AWS Management Console, the AWS CLI, or the Amazon RDS API.
To modify a zero-ETL integration
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/
. -
In the navigation pane, choose Zero-ETL integrations, and then choose the integration that you want to modify.
-
Choose Modify and make modifications to any available settings.
-
When all the changes are as you want them, choose Modify.
To modify a zero-ETL integration using the AWS CLI, call the modify-integration
command. Along with the --integration-identifier, specify any of the
following options:
-
--integration-name– Specify a new name for the integration. -
--description– Specify a new description for the integration. -
--data-filter– Specify data filtering options for the integration. For more information, see Data filtering for Aurora zero-ETL integrations with Amazon Redshift.
The following request modifies an existing integration.
For Linux, macOS, or Unix:
aws rds modify-integration \ --integration-identifieree605691-6c47-48e8-8622-83f99b1af374\ --integration-namemy-renamed-integration
For Windows:
aws rds modify-integration ^ --integration-identifieree605691-6c47-48e8-8622-83f99b1af374^ --integration-namemy-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.
