Removing association of a datashare from data consumers in a different Amazon Web Services account in Amazon Redshift - Amazon Redshift
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).

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

With Amazon Redshift, you can remove association from datashares shared by other Amazon Web Services 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 Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/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.