Query: emr_cluster_status

select
  status -> 'StateChangeReason' ->> 'Code' as "Code",
  status -> 'StateChangeReason' ->> 'Message' as "Message",
  status -> 'Timeline' ->> 'CreationDateTime' as "Creation Time",
  status -> 'Timeline' ->> 'ReadyDateTime' as "Ready Time",
  status -> 'Timeline' ->> 'EndDateTime' as "End Time"
from
  aws_emr_cluster
where
  cluster_arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);