Workgroups and namespaces - Amazon Redshift
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).

Workgroups and namespaces

To isolate workloads and manage different resources in Amazon Redshift Serverless, you can create namespaces and workgroups and manage storage and compute resources separately.

A namespace is a collection of database objects and users. The storage-related namespace groups together schemas, tables, users, or Amazon Key Management Service keys for encrypting data. Storage properties include the database name and password of the admin user, permissions, and encryption and security. Other resources that are grouped under namespaces include datashares, recovery points, and usage limits. You can configure these storage properties using the Amazon Redshift Serverless console, the Amazon Command Line Interface, or the Amazon Redshift Serverless APIs for the specific resource.

Workgroup is a collection of compute resources. The compute-related workgroup groups together compute resources like RPUs, VPC subnet groups, and security groups. Properties for the workgroup include network and security settings. Other resources that are grouped under workgroups include access and usage limits. You can configure these compute properties using the Amazon Redshift Serverless console, the Amazon Command Line Interface, or the Amazon Redshift Serverless APIs.

You can create one or more namespaces and workgroups. Each namespace can have only one workgroup associated with it. Conversely, each workgroup can be associated with only one namespace.

Workgroups and namespaces using the console

Setting up Amazon Redshift Serverless involves walking through several configuration steps. When you follow the steps to set up Amazon Redshift Serverless, you create a namespace and workgroup, and associate them with each other. To get started setting Amazon Redshift Serverless configuration using the Amazon Redshift Serverless console, you can choose Get started with Amazon Redshift Serverless to set up Amazon Redshift Serverless and begin to interact with it. You can choose an environment with default settings, which makes for quicker setup, or explicitly configure the settings per your organization's requirements.During this process, you specify settings for your workgroup and namespace.

After you set up the environment, Workgroup properties and Namespace properties help you get familiar with the settings.

Workgroups and namespaces using the Amazon Command Line Interface and Amazon Redshift Serverless API

Aside from using the Amazon console, you can also use the Amazon CLI or the Amazon Redshift Serverless API to interact with workgroups and namespaces. The table below lists the API and CLI operations you can use to manage snapshots and recovery points.

API operation CLI command Description

CreateNamespace

create-namespace

Creates a namespace. By default, Amazon Redshift Serverless creates namespaces with a default Amazon Key Management Service key, but you can specify another key to encrypt your data. You can also create a namespace by restoring a snapshot. See Working with snapshots and recovery points for more information.

UpdateNamespace

update-namespace

Updates a namespace.

GetNamespace

get-namespace

Retrieves information about a namespace

ListNamepaces

list-namespaces

Retrieves information about a list of namespaces.

DeleteNamespace

delete-namespace

Deletes a namespace.

CreateWorkgroup

create-workgroup

Creates a workgroup. When creating a workgroup, make sure that you have an existing namespace that you can associate with the workgroup. When creating the workgroup, you can specify compute resources such as subnets, security groups, and RPUs.

UpdateWorkgroup

update-workgroup

Updates a workgroup.

GetWorkgroup

get-workgroup

Retrieves information about a workgroup.

ListWorkgroups

list-workgroups

Retrieves information about a list of workgroups.

DeleteWorkgroup

delete-workgroup

Deletes a workgroup.