Query: cloudtrail_trail_bucket

select
  s3_bucket_name as "S3 Bucket Name",
  s.arn as "S3 Bucket ARN"
from
  aws_cloudtrail_trail as t left join aws_s3_bucket as s on s.name = t.s3_bucket_name
where
  t.region = home_region
  and t.arn = $1;