Difference between revisions of "Aws redshift describe-clusters"

From wikieduonline
Jump to navigation Jump to search
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{lowercase}}
 
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 | 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 ==
 +
* <code>[[NodeType]]: [[dc2.large]]</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: