You can delete a datashare created in your account using the console or with SQL.
To delete a datashare created in your account using the console, first connect to a database to see the list of datashares created in your account.
Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/
. -
On the navigation menu, choose Clusters, then choose your cluster. The cluster details page appears.
-
Choose Datashares. The datashare list appears.
-
In the Datashares created in my account section, choose Connect to database.
-
Choose one or more datashares you want to delete, then choose Delete. The Delete datashares page appears.
Deleting a datashare shared with Lake Formation doesn't automatically remove the associated permissions in Lake Formation. To remove them, go to the Lake Formation console.
-
Type Delete to confirm deleting the specified datashares.
-
Choose Delete.
After datashares are deleted, datashare consumers lose access to the datashares.
