Table: aws_redshiftserverless_namespace

Amazon Redshift Serverless namespaces are collections of database objects and users. The storage-related namespace groups together schemas, tables, users, or AWS 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.

Examples

Basic info

select
  namespace_name,
  namespace_arn,
  namespace_id,
  creation_date,
  db_name,
  region,
  status
from
  aws_redshiftserverless_namespace;

List all unavailable namespaces

select
  namespace_name,
  namespace_arn,
  namespace_id,
  creation_date,
  db_name,
  region,
  status
from
  aws_redshiftserverless_namespace
where
  status <> 'AVAILABLE';

List all unencrypted namespaces

select
  namespace_name,
  namespace_arn,
  namespace_id,
  creation_date,
  db_name,
  region,
  status
from
  aws_redshiftserverless_namespace
where
  kms_key_id is null;

Get default IAM role ARN associated with each namespace

select
  namespace_name,
  namespace_arn,
  namespace_id,
  creation_date,
  default_iam_role_arn
from
  aws_redshiftserverless_namespace;