Control: Redshift Serverless namespaces should not use the default database name

Description

This control checks whether an Amazon Redshift Serverless namespace uses the default database name, dev. The control fails if the Redshift Serverless namespace uses the default database name, dev.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.redshiftserverless_namespace_no_default_database_username

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.redshiftserverless_namespace_no_default_database_username --share

SQL

This control uses a named query:

select
  namespace_arn as resource,
  case
    when db_name = 'dev' then 'alarm'
    else 'ok'
  end as status,
  case
    when db_name = 'dev' then title || ' uses default database name.'
    else title || ' not uses default database name.'
  end as reason
  
  , region, account_id
from
  aws_redshiftserverless_namespace;

Control: Redshift Serverless namespaces should not use the default database name

Description

Usage

SQL

Tags