Control: 4 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.

Audit logs track and monitor system activities. They provide a record of events that can help you detect security breaches, investigate incidents, and comply with regulations. Audit logs also enhance the overall accountability and transparency of your organization.

Remediation

For information about enabling logging for an Athena workgroup, see Enable CloudWatch query metrics in Athena in the Amazon Athena User Guide.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.foundational_security_athena_4

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.foundational_security_athena_4 --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_id
from
  aws_athena_workgroup;

Control: 4 Athena workgroups should have logging enabled

Description

Remediation

Usage

SQL

Tags