View a markdown version of this page

Deregister from Amazon Redshift federated permissions - Amazon Redshift
IAM Policy Requirements for Amazon Redshift Federated Permissions DeregistrationDeregister Redshift clusterDeregister Redshift Serverless namespace
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 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.

Deregister from Amazon Redshift federated permissions

IAM Policy Requirements for Amazon Redshift Federated Permissions Deregistration

To deregister your cluster or serverless namespace, below IAM permissions are required.

For Redshift Provisioned Clusters

  • redshift:ModifyLakehouseConfiguration

  • redshift:DeregisterNamespace

For Redshift Serverless

  • redshift-serverless:UpdateLakehouseConfiguration

  • redshift:DeregisterNamespace

If you are deregistering a warehouse that was registered with the Amazon Glue Data Catalog, the following additional permissions are required:

For Amazon Glue Data Catalog Integration

  • glue:DeleteCatalog

  • glue:GetCatalog

For Lake Formation Resource Registration

  • lakeformation:DeregisterResource

Deregister Redshift cluster

CLI

Use the modify-lakehouse-configuration command to deregister your cluster. If you have an IdC provider associated with your cluster, it is put into disabled mode.

aws redshift modify-lakehouse-configuration \
--cluster-identifier 'redshift-cluster' \
--lakehouse-registration Deregister
Console

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshiftv2/.

  2. Navigate to the provisioned cluster that you want to de-register and select it.

  3. From the cluster's details page, select Deregister from Amazon Redshift multi-warehouse from the Actions drop-down menu and choose Deregister.

Deregister Redshift Serverless namespace

CLI

Use the update-lakehouse-configuration command to deregister your Redshift Serverless namespace. If you have an IdC provider associated with your namespace, it is put into disabled mode.

aws redshift-serverless update-lakehouse-configuration \
--namespace-name 'serverless-namespace-name' \
--lakehouse-registration Deregister
Console

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshiftv2/.

  2. Navigate to serverless namespace cluster that you want to de-register and select it.

  3. From the cluster's details page, select Deregister from Amazon Redshift multi-warehouse from the Actions drop-down menu and choose Deregister.