Difference between revisions of "Aws redshift describe-clusters"

From wikieduonline
Jump to navigation Jump to search
 
(17 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
https://docs.aws.amazon.com/cli/latest/reference/redshift/describe-clusters.html
 
https://docs.aws.amazon.com/cli/latest/reference/redshift/describe-clusters.html
  
 +
[[aws redshift]] describe-clusters | grep ClusterIdentifier
 +
aws redshift describe-clusters | egrep -w "ClusterIdentifier|Address"
 +
aws redshift describe-clusters | egrep -w "ClusterIdentifier|Address|MasterUsername|DBName"
 +
aws redshift describe-clusters | egrep "NodeType|NumberOfNodes"
 +
aws redshift describe-clusters | egrep -w "NodeType|NumberOfNodes|[[ClusterStatus]]"
  
 
  [[aws]] redshift describe-clusters [[--output text]]
 
  [[aws]] redshift describe-clusters [[--output text]]
  aws redshift describe-clusters --output text | grep [[ENDPOINT]]
+
  aws redshift describe-clusters | egrep "[[NodeType]]|NumberOfNodes"
aws redshift describe-clusters | grep ClusterIdentifier
 
aws redshift describe-clusters  | grep NumberOfNodes
 
  
 
== 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 ==
 +
* <code>[[NodeType]]: [[dc2.large]]</code>
 
* <code>[[aws list all]]</code>
 
* <code>[[aws list all]]</code>
 +
* <code>[[aws rds describe-db-instances]]</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 23:35, 10 May 2022

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

aws redshift describe-clusters | grep ClusterIdentifier
aws redshift describe-clusters | egrep -w "ClusterIdentifier|Address"
aws redshift describe-clusters | egrep -w "ClusterIdentifier|Address|MasterUsername|DBName"
aws redshift describe-clusters | egrep "NodeType|NumberOfNodes"
aws redshift describe-clusters | egrep -w "NodeType|NumberOfNodes|ClusterStatus"
aws redshift describe-clusters --output text
aws redshift describe-clusters | egrep "NodeType|NumberOfNodes"

Output[edit]

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[edit]

See also[edit]

Advertising: