Control: S3 buckets should have event notifications enabled

powerpipe control run aws_compliance.control.s3_bucket_event_notifications_enabled

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

select
  arn as resource,
  case
    when
      event_notification_configuration ->> 'EventBridgeConfiguration' is null
      and event_notification_configuration ->> 'LambdaFunctionConfigurations' is null
      and event_notification_configuration ->> 'QueueConfigurations' is null
      and event_notification_configuration ->> 'TopicConfigurations' is null then 'alarm'
    else 'ok'
  end as status,
  case
    when
      event_notification_configuration ->> 'EventBridgeConfiguration' is null
      and event_notification_configuration ->> 'LambdaFunctionConfigurations' is null
      and event_notification_configuration ->> 'QueueConfigurations' is null
      and event_notification_configuration ->> 'TopicConfigurations' is null then title || ' event notifications disabled.'
    else title || ' event notifications enabled.'
  end as reason
  
  , region, account_id
from
  aws_s3_bucket;