Difference between revisions of "Aws redshift describe-clusters"

From wikieduonline
Jump to navigation Jump to search
Line 10: Line 10:
 
== Output ==
 
== Output ==
 
Oficial AWS documentation:
 
Oficial AWS documentation:
<pre>
+
 
{
+
{
  "Clusters": [
+
    "Clusters": [
  {
+
    {
      "NodeType": "dw.hs1.xlarge",
+
      "NodeType": "dw.hs1.xlarge",
      "Endpoint": {
+
      "Endpoint": {
        "Port": 5439,
+
          "Port": 5439,
        "Address": "mycluster.coqoarplqhsn.us-east-1.redshift.amazonaws.com"
+
          "Address": "mycluster.coqoarplqhsn.us-east-1.redshift.amazonaws.com"
      },
+
      },
      "ClusterVersion": "1.0",
+
      "ClusterVersion": "1.0",
      "PubliclyAccessible": "true",
+
      "PubliclyAccessible": "true",
      "MasterUsername": "adminuser",
+
      "MasterUsername": "adminuser",
      "ClusterParameterGroups": [
+
      "ClusterParameterGroups": [
        {
+
          {
            "ParameterApplyStatus": "in-sync",
+
            "ParameterApplyStatus": "in-sync",
            "ParameterGroupName": "default.redshift-1.0"
+
            "ParameterGroupName": "default.redshift-1.0"
        } ],
+
          } ],
      "ClusterSecurityGroups": [
+
      "ClusterSecurityGroups": [
        {
+
          {
 
             "Status": "active",
 
             "Status": "active",
            "ClusterSecurityGroupName": "default"
+
            "ClusterSecurityGroupName": "default"
        } ],
+
          } ],
      "AllowVersionUpgrade": true,
+
      "AllowVersionUpgrade": true,
      "VpcSecurityGroups": \[],
+
      "VpcSecurityGroups": \[],
      "AvailabilityZone": "us-east-1a",
+
      "AvailabilityZone": "us-east-1a",
      "ClusterCreateTime": "2013-01-22T21:59:29.559Z",
+
      "ClusterCreateTime": "2013-01-22T21:59:29.559Z",
      "PreferredMaintenanceWindow": "sat:03:30-sat:04:00",
+
      "PreferredMaintenanceWindow": "sat:03:30-sat:04:00",
      "AutomatedSnapshotRetentionPeriod": 1,
+
      "AutomatedSnapshotRetentionPeriod": 1,
      "ClusterStatus": "available",
+
      "ClusterStatus": "available",
      "ClusterIdentifier": "mycluster",
+
      "ClusterIdentifier": "mycluster",
      "DBName": "dev",
+
      "DBName": "dev",
      "NumberOfNodes": 2,
+
      "NumberOfNodes": 2,
      "PendingModifiedValues": {}
+
      "PendingModifiedValues": {}
  } ],
+
    } ],
  "ResponseMetadata": {
+
    "ResponseMetadata": {
      "RequestId": "65b71cac-64df-11e2-8f5b-e90bd6c77476"
+
      "RequestId": "65b71cac-64df-11e2-8f5b-e90bd6c77476"
  }
+
    }
}
+
}
</pre>
 
  
 
== Related ==
 
== Related ==

Revision as of 13:32, 26 January 2022

https://docs.aws.amazon.com/cli/latest/reference/redshift/describe-clusters.html


aws redshift describe-clusters --output text
aws redshift describe-clusters --output text | grep ENDPOINT
aws redshift describe-clusters | grep ClusterIdentifier
aws redshift describe-clusters | egrep "NodeType|NumberOfNodes"

Output

Oficial AWS documentation:

{
   "Clusters": [
   {
      "NodeType": "dw.hs1.xlarge",
      "Endpoint": {
         "Port": 5439,
         "Address": "mycluster.coqoarplqhsn.us-east-1.redshift.amazonaws.com"
      },
      "ClusterVersion": "1.0",
      "PubliclyAccessible": "true",
      "MasterUsername": "adminuser",
      "ClusterParameterGroups": [
         {
            "ParameterApplyStatus": "in-sync",
            "ParameterGroupName": "default.redshift-1.0"
         } ],
      "ClusterSecurityGroups": [
         {
           "Status": "active",
            "ClusterSecurityGroupName": "default"
         } ],
      "AllowVersionUpgrade": true,
      "VpcSecurityGroups": \[],
      "AvailabilityZone": "us-east-1a",
      "ClusterCreateTime": "2013-01-22T21:59:29.559Z",
      "PreferredMaintenanceWindow": "sat:03:30-sat:04:00",
      "AutomatedSnapshotRetentionPeriod": 1,
      "ClusterStatus": "available",
      "ClusterIdentifier": "mycluster",
      "DBName": "dev",
      "NumberOfNodes": 2,
      "PendingModifiedValues": {}
   } ],
   "ResponseMetadata": {
      "RequestId": "65b71cac-64df-11e2-8f5b-e90bd6c77476"
   }
}

Related

See also

Advertising: