Query: iam_policy_overview

select
  name as "Name",
  path as "Path",
  create_date as "Create Date",
  update_date as "Update Date",
  policy_id as "Policy ID",
  arn as "ARN",
  case
    is_aws_managed
    when true then 'AWS Managed'
    else account_id
  end as "Account ID"
from
  aws_iam_policy
where
  arn = $1
limit
  1