Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Removing association of a datashare from data consumers in a different AWS account in Amazon Redshift - Amazon Redshift

Removing association of a datashare from data consumers in a different AWS account in Amazon Redshift

With Amazon Redshift, you can remove association from datashares shared by other AWS accounts. Datashares are shareable database objects that encapsulate data from one or more Redshift databases. The following sections demonstrate the process of disassociating datashares within your Redshift environment.

Console

As a consumer administrator, you can remove association of datashares from data consumers on the console.

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

  2. On the navigation menu, choose Datashares. The datashare list page appears.

  3. Choose From other accounts.

  4. In the Datashares from other accounts section, choose the datashare to remove association from data consumers.

  5. In the Data consumers section, choose one or more data consumers to remove association from. Then choose Remove association.

  6. When the Remove association page appears, choose Remove association.

After association is removed, data consumers will lose access to the datashare. You can change the data consumer association at any time.

SQL
Note

The steps in this section are performed after the producer administrator grants specific actions on the shared database objects and, if the datashare is being shared with another account, the producer security administrator authorizes access.

The consumer security administrator can disassociate the datashare with the following command:

disassociate-data-share-consumer --data-share-arn <value>

For more information about the command, see disassociate-data-share-consumer.

As a consumer administrator, you can remove association of datashares from data consumers on the console.

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

  2. On the navigation menu, choose Datashares. The datashare list page appears.

  3. Choose From other accounts.

  4. In the Datashares from other accounts section, choose the datashare to remove association from data consumers.

  5. In the Data consumers section, choose one or more data consumers to remove association from. Then choose Remove association.

  6. When the Remove association page appears, choose Remove association.

After association is removed, data consumers will lose access to the datashare. You can change the data consumer association at any time.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.