Control: Athena workgroups should have logging enabled
Description
This control checks whether an Amazon Athena workgroup has logging enabled. The control fails if the workgroup doesn't have logging enabled.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.athena_workgroup_logging_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.athena_workgroup_logging_enabled --share
SQL
This control uses a named query:
select name as resource, case when publish_cloudwatch_metrics_enabled then 'ok' else 'alarm' end as status, case when publish_cloudwatch_metrics_enabled then name || ' workgroup logging enabled.' else name || ' workgroup logging disabled.' end as reason , region, account_idfrom aws_athena_workgroup;