Table: aws_vpc_flow_log

VPC Flow Logs is a feature that enables to capture information about the IP traffic going to and from network interfaces in the VPC.

Examples

List flow logs with their corresponding VPC Ids, subnet Ids, or network interface Ids

select
  flow_log_id,
  resource_id
from
  aws_vpc_flow_log;

List of flow logs whose logs delivery has failed

select
  flow_log_id,
  resource_id,
  deliver_logs_error_message,
  deliver_logs_status
from
  aws_vpc_flow_log
where
  deliver_logs_status = 'FAILED';

Log group or destination bucket information to which the flow log is published

select
  flow_log_id,
  log_destination_type,
  log_destination,
  log_group_name,
  bucket_name
from
  aws_vpc_flow_log;

Type of traffic captured by each flow log

select
  flow_log_id,
  traffic_type
from
  aws_vpc_flow_log;