Query: s3_bucket_server_side_encryption

select
  rules -> 'ApplyServerSideEncryptionByDefault' ->> 'KMSMasterKeyID' as "KMS Master Key ID",
  rules -> 'ApplyServerSideEncryptionByDefault' ->> 'SSEAlgorithm' as "SSE Algorithm",
  rules -> 'BucketKeyEnabled' as "Bucket Key Enabled"
from
  aws_s3_bucket,
  jsonb_array_elements(server_side_encryption_configuration -> 'Rules') as rules
where
  arn = $1;