Managing AWS Data Exchange datashares - Amazon Redshift
Creating data sets on AWS Data ExchangeEditing AWS Data Exchange datasharesDeleting AWS Data Exchange datashares created in your account

Managing AWS Data Exchange datashares

With Amazon Redshift, you can securely share and receive live data from AWS Data Exchange without having to create and manage data extracts or pipelines. Managing AWS Data Exchange datashares allows you to subscribe to third-party data products and integrate live data streams directly into your Amazon Redshift data warehouse. The following sections demonstrate managing AWS Data Exchange datashares within your Amazon Redshift clusters.

Creating data sets on AWS Data Exchange

Create data sets on AWS Data Exchange.

  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 Clusters, then choose your cluster. The cluster details page appears.

  3. Choose Datashares.

  4. In the Datashares created in my account section, choose an AWS Data Exchange datashare.

  5. Choose Create data set on AWS Data Exchange. For more information, see Publishing a new product.

Editing AWS Data Exchange datashares

Edit AWS Data Exchange datashares using the console. Connect to a database first to see the list of datashares created in your account.

For AWS Data Exchange datashares, you can't make changes to data consumers.

To edit the publicly accessible setting for AWS Data Exchange datashares, use the Query editor v2. Amazon Redshift generates a random one-time value to set the session variable to allow turning this setting off. For more information, see ALTER DATASHARE usage notes.

  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 Clusters, then choose your cluster. The cluster details page appears.

  3. From the navigator menu, choose Editor, then Query editor v2.

  4. If this is the first time you use the Query editor v2, configure your AWS account. By default, an AWS owned key is used to encrypt resources. For more information about configuring your AWS account, see Configuring your AWS account in the Amazon Redshift Management Guide.

  5. To connect to the cluster that your AWS Data Exchange datashare is in, choose Database and the cluster name in the tree-view panel. If prompted, enter the connection parameters.

  6. Copy the following SQL statement. The following example changes the publicly accessible setting of the salesshare datashare.

    ALTER DATASHARE salesshare SET PUBLICACCESSIBLE FALSE;

  7. To run the copied SQL statement, choose Queries and paste the copied SQL statement in the query area. Then choose Run.

    An error appears following:

    ALTER DATASHARE salesshare SET PUBLICACCESSIBLE FALSE;
ERROR:  Alter of ADX-managed datashare salesshare requires session variable datashare_break_glass_session_var to be set to value 'c670ba4db22f4b'

    The value 'c670ba4db22f4b' is a random one-time value that Amazon Redshift generates when an unrecommended operation occurs.

  8. Copy and paste the following sample statement into the query area. Then run the command. The SET datashare_break_glass_session_var command applies a permission to allow an unrecommended operation for an AWS Data Exchange datashare.

    SET datashare_break_glass_session_var to 'c670ba4db22f4b';

  9. Run the ALTER DATASHARE statement again.

    ALTER DATASHARE salesshare;

Amazon Redshift updates your datashare with the changes.

Deleting AWS Data Exchange datashares created in your account

Delete AWS Data Exchange datashares created in your account using the console. Connect to a database first to see the list of datashares created in your account.

  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 Clusters, then choose your cluster. The cluster details page appears.

  3. From the navigator menu, choose Editor, then Query editor v2.

  4. If this is the first time you use the Query editor v2, configure your AWS account. By default, an AWS owned key is used to encrypt resources. For more information about configuring your AWS account, see Configuring your AWS account in the Amazon Redshift Management Guide.

  5. To connect to the cluster that your AWS Data Exchange datashare is in, choose Database and the cluster name in the tree-view panel. If prompted, enter the connection parameters.

  6. Copy the following SQL statement. The following example drops the salesshare datashare.

    DROP DATASHARE salesshare

  7. To run the copied SQL statement, choose Queries and paste the copied SQL statement in the query area. Then choose Run.

    An error appears following:

    ERROR:  Drop of ADX-managed datashare salesshare requires session variable datashare_break_glass_session_var to be set to value '620c871f890c49'

    The value '620c871f890c49' is a random one-time value that Amazon Redshift generates when an unrecommended operation occurs.

  8. Copy and paste the following sample statement into the query area. Then run the command. The SET datashare_break_glass_session_var command applies a permission to allow an unrecommended operation for an AWS Data Exchange datashare.

    SET datashare_break_glass_session_var to '620c871f890c49';

  9. Run the DROP DATASHARE statement again.

    DROP DATASHARE salesshare;

After the datashare is deleted, datashare consumers lose access to the datashare.

Deleting a shared AWS Data Exchange datashare can breach data product terms in AWS Data Exchange.