Query: emr_cluster_applications

select
  app ->> 'Name' as "Name",
  app ->> 'Version' as "Version",
  app -> 'Args' as "Args",
  app -> 'AdditionalInfo' as "Additional Info"
from
  aws_emr_cluster,
  jsonb_array_elements(applications) as app
where
  cluster_arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);