turbot/aws_insights

Query: api_gatewayv2_api_by_account

Usage

powerpipe query aws_insights.query.api_gatewayv2_api_by_account

SQL

select
acc.title as "Account",
count(api.*)
from
aws_api_gatewayv2_api as api,
aws_account as acc
where
api.account_id = acc.account_id
group by
acc.title
order by
acc.title;

Dashboards

The query is used in the dashboards: