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

Deleting Aurora zero-ETL integrations with Amazon Redshift

When you delete a zero-ETL integration, Amazon Aurora removes it from the source Aurora DB cluster. Your transactional data isn't deleted from Amazon Aurora or Amazon Redshift, but Aurora 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 Amazon Web Services Management Console, the Amazon CLI, or the RDS API.

To delete 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/.

    If the integration has an Aurora PostgreSQL source DB cluster, you must sign in to the Amazon RDS Database Preview Environment at https://us-east-2.console.aws.amazon.com/rds-preview/home?region=us-east-2#databases.

  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.

Note

During the preview of Aurora PostgreSQL zero-ETL integrations, you can only delete integrations through the Amazon Web Services Management Console. You can't use the Amazon CLI, the Amazon RDS API, or any of the SDKs.

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
Note

During the preview of Aurora PostgreSQL zero-ETL integrations, you can only delete integrations through the Amazon Web Services Management Console. You can't use the Amazon CLI, the Amazon RDS API, or any of the SDKs.

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