Query: redshift_cluster_logging_table

select
  c.cluster_identifier as "Cluster Identifier",
  case
    when logging_status ->> 'LoggingEnabled' = 'true' then 'Enabled'
    else null
  end as "Logging",
  c.logging_status ->> 'BucketName' as "S3 Bucket Name",
  c.logging_status ->> 'S3KeyPrefix' as "S3 Key Prefix",
  c.logging_status ->> 'LastFailureTime' as "Last Failure Time",
  c.logging_status ->> 'LastSuccessfulDeliveryTime' as "Last Successful Delivery Time",
  a.title as "Account",
  c.account_id as "Account ID",
  c.region as "Region",
  c.arn as "ARN"
from
  aws_redshift_cluster as c,
  aws_account as a
where
  c.account_id = a.account_id
order by
  c.cluster_identifier;