How to create dataframe in R of available redshift clusters using aws cli
<p>I would like to use the <code>aws cli</code> to create a dataframe in R that contains each of the available redshift clusters that I have, output example below: </p>

<pre><code>cluster_identifier
my-cluster-1
my-cluster-1
</code></pre>

<p>The command: <code>system(intern = TRUE, "aws redshift describe-clusters")</code> brings back a whole list of information about each cluster, but I don't know how to restrict this json output to bring back just the cluster_identifier, and secondly how to then read it into an R dataframe in a usable format</p>

<p>I tried wrapping the above system command with <code>fromJSON</code> but this returned the error: </p>

<pre><code>Error in fromJSON(system(intern = TRUE, paste0("aws redshift describe-clusters"))) : 
  incomplete list
</code></pre>