Query: iam_role_overview

select
  name as "Name",
  create_date as "Create Date",
  permissions_boundary_arn as "Boundary Policy",
  role_id as "Role ID",
  arn as "ARN",
  account_id as "Account ID"
from
  aws_iam_role
where
  arn = $1
  and account_id = split_part($1, ':', 5);