Removing datashare objects from a datashare in Amazon Redshift - Amazon Redshift
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

Removing datashare objects from a datashare in Amazon Redshift

You can remove one or more objects from a datashare by using the following procedure.

Console

To remove one or more objects from a datashare on the consoe, follow these steps.

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://eusc-de-east-1.console.amazonaws-eusc.eu/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 Connect to database. For more information, see Connecting to a database.

  5. Choose the datashare you want to edit, then choose Edit. The datashare details page appears.

  6. To remove one or more datashare objects to the datashare, do one of the following:

    • To remove schemas from the datashare, choose one or more schemas. Then choose Remove. Amazon Redshift removes the specified schemas and all the objects of the specified schemas from the datashare.

    • To remove tables and views from the datashare, choose one or more tables and views. Then choose Remove. Alternatively, choose Remove by schema to remove all tables and views in the specified schemas.

    • To remove user-defined functions from the datashare, choose one or more user-defined functions. Then choose Remove. Alternatively, choose Remove by schema to remove all user-defined functions in the specified schemas.

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;