Query: redshift_cluster_node_details

select
  p ->> 'NodeRole' as "Node Role",
  p ->> 'PrivateIPAddress' as "PrivateIP Address",
  p ->> 'PublicIPAddress' as "PublicIP Address"
from
  aws_redshift_cluster,
  jsonb_array_elements(cluster_nodes) as p
where
  arn = $1;