Query: vpc_flow_log_destination

select
  log_destination_type as "Log Destination Type",
  case when log_destination like 'arn:aws:s3%' then log_destination else 'NA' end as "Bucket",
  case
    when log_destination like '%:log-group:%' then log_destination
    When log_group_name is not null then log_group_name
    else 'NA' end as "Log Group"
from
  aws_vpc_flow_log
where
  flow_log_id = $1