Control: Redshift clusters should not use the default database name
Description
This control checks whether an AWS Redshift cluster has changed the database name from its default value. The control will fail if the database name for a Redshift cluster is set to dev.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.redshift_cluster_no_default_database_nameSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.redshift_cluster_no_default_database_name --shareSQL
This control uses a named query:
select arn as resource, case when db_name = 'dev' then 'alarm' else 'ok' end as status, case when db_name = 'dev' then title || ' using default database name.' else title || ' not using default database name.' end as reason , region, account_idfrom aws_redshift_cluster;