Query: ram_role_overview

select
  name as "Name",
  create_date as "Create Date",
  update_date as "Last Update Date",
  max_session_duration as "Max Session Duration",
  description as "Description",
  role_id as "Role ID",
  arn as "ARN",
  account_id as "Account ID"
from
  alicloud_ram_role
where
  arn = $1
  and account_id = split_part($1,':',4);