Query: api_gatewayv2_api_table

select
  api.name as "Name",
  api.api_id as "ID",
  now()::date - api.created_date::date as "Age in Days",
  api.created_date as "Create Time",
  api.protocol_type as "Protocol",
  acc.title as "Account",
  api.account_id as "Account ID",
  api.region as "Region"
from
  aws_api_gatewayv2_api as api,
  aws_account as acc
where
  api.account_id = acc.account_id
order by
  api.created_date,
  api.name;