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).
Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
.
Editing datashares created in your account in
Amazon Redshift
You can edit a datashare created in your account using the console and with
SQL.
- Console
-
On the console, take the following steps to connect to a database
first to see the list of datashares created in your account.
Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at
https://console.amazonaws.cn/redshiftv2/.
-
On the navigation menu, choose Clusters,
then choose your cluster. The cluster details page appears.
-
Choose Datashares.
-
In the Datashares created in my account
section, choose Connect to database.
-
Choose the datashare you want to edit, then choose
Edit. The datashare details page
appears.
-
Make any changes in the Datashare objects
or Data consumers section.
-
Choose Save changes. Amazon Redshift updates your
datashare with the changes.
If you chose to publish your datashare to the Amazon Glue Data Catalog,
you can't edit the configuration to publish the datashare
to other Amazon Redshift accounts.
- SQL
-
Use ALTER DATASHARE to remove objects from datashares at any point
from the datashare. To remove a schema, use the following command:
ALTER DATASHARE salesshare REMOVE SCHEMA PUBLIC;
To remove a table, use the following command:
ALTER DATASHARE salesshare REMOVE TABLE public.tickit_sales_redshift;
Use REVOKE USAGE ON to revoke permissions on the datashare to certain
consumers. It revokes USAGE permissions on objects within a datashare and
instantly stops access to all consumer clusters. Listing datashares and
the metadata queries, such as listing databases and tables, doesn't
return the shared objects after access is revoked. Revoke access to the
datashare from namespaces if you don't want to share the data with
the consumers anymore.
REVOKE USAGE ON DATASHARE salesshare FROM NAMESPACE '13b8833d-17c6-4f16-8fe4-1a018f5ed00d';
If you don't want to share the data with the consumers anymore, revoke
access to the datashare from Amazon Web Services accounts:
REVOKE USAGE ON DATASHARE salesshare FROM ACCOUNT '123456789012';