Query: Top 10 ENIs by Traffic

select
  interface_id as "ENI",
  vpc_id as "VPC",
  subnet_id as "Subnet",
  account_id as "Account",
  region as "Region",
  count(*) as "Records",
  coalesce(sum(bytes), 0) as "Total Bytes",
  coalesce(sum(packets), 0) as "Total Packets",
  max(start_time) as "Last Seen"
from
  aws_vpc_flow_log
where
  interface_id is not null
group by
  interface_id,
  vpc_id,
  subnet_id,
  account_id,
  region
order by
  "Records" desc
limit 10;