Query: s3_buckets_for_cloudtrail_trail

select
  s.arn as s3_bucket_arn
from
  aws_cloudtrail_trail as t,
  aws_s3_bucket as s
where
  t.region = t.home_region
  and t.s3_bucket_name = s.name
  and s3_bucket_name is not null
  and t.arn = $1;