Deleting Amazon RDS zero-ETL integrations with Amazon Redshift - Amazon Relational Database Service

Deleting Amazon RDS zero-ETL integrations with Amazon Redshift

When you delete a zero-ETL integration, Amazon RDS removes it from the source database. Your transactional data isn't deleted from Amazon RDS or Amazon Redshift, but Amazon RDS doesn't send new data to Amazon Redshift.

You can only delete an integration when it has a status of Active, Failed, Syncing, or Needs attention.

You can delete zero-ETL integrations using the AWS Management Console, the AWS CLI, or the RDS API.

To delete a zero-ETL integration

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. From the left navigation pane, choose Zero-ETL integrations.

  3. Select the zero-ETL integration that you want to delete.

  4. Choose Actions, Delete, and confirm deletion.

To delete a zero-ETL integration, use the delete-integration command and specify the --integration-identifier option.

For Linux, macOS, or Unix:

aws rds delete-integration \
    --integration-identifier ee605691-6c47-48e8-8622-83f99b1af374

For Windows:

aws rds delete-integration ^
    --integration-identifier ee605691-6c47-48e8-8622-83f99b1af374

To delete a zero-ETL integration using the Amazon RDS API, use the DeleteIntegration operation with the IntegrationIdentifier parameter.