Change the workgroup name in a redshift cluster

With Redshift provisioned clusters, you can rename the cluster without deleting it (simply select "Edit" in the console and change the cluster identifier).

For Serverless workgroups, you cannot change the workgroup name itself; however, permissions, schemas, and users are stored at the "namespace" level rather than the workgroup level. Therefore, you can:

1. Keep the namespace intact without deleting it
2. Delete only the workgroup
3. Recreate the workgroup with a new name, specifying the same namespace

This eliminates the need to re-grant permissions or re-run tests. Note that the endpoint (connection target) will change, so you will need to update the connection settings in your application.

Based on the available information, there is no direct way to rename a workgroup in Amazon Redshift Serverless. The workgroup name is a fixed identifier that cannot be changed after creation.

However, you can update various properties and configurations of an existing workgroup without deleting it using the update-workgroup command. This allows you to modify settings such as configuration parameters, network settings, security groups, and other workgroup properties while keeping the same workgroup name and maintaining all existing permissions and configurations.

If you absolutely need to change the workgroup name itself, the only option is to delete the existing workgroup and create a new one with the desired name. Unfortunately, this would require you to reconfigure permissions and retest as you mentioned.

Before making any changes, I recommend carefully evaluating whether you truly need to change the workgroup name, or if updating the workgroup's configuration parameters would meet your needs. If a name change is necessary, plan for the reconfiguration work and consider documenting your current setup thoroughly before deletion to streamline the recreation process.
Sources
Unlock granular resource control with queue-based QMR in Amazon Redshift Serverless | AWS Big Data Blog
Workgroups and namespaces - Amazon Redshift