Aws redshift describe-clusters

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 --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

• NodeType: dc2.large
• aws list all
• aws rds describe-db-instances

See also

• Amazon Redshift: aws redshift, aws redshift describe-clusters, aws redshift describe-events, aws redshift create-cluster
• AWS CLI, aws [ configure | iam | ec2 | ecs | eks | s3 | rds | sts | cloudwatch | cloudformation | cloudfront | eventbridge | lambda ], aws configure list, .aws/credentials, .aws/config, ~/.aws/cli/alias, --output [ table | json | text | XXX ], Aws cli environmental variables: AWS_PROFILE, AWS_DEFAULT_REGION, AWS_REGION, AWS_CLI_AUTO_PROMPT, AWS_SESSION_TOKEN, aws list all, auto-prompt, --version, whoamiaws, --filters, --help