Amazon Redshift

Least Privileged User

Navigate to the AWS console and create an IAM user with programmatic access. The user will need the following permissions. You can create a policy specifically for these permissions and apply the permissions to the user.

For more information, see: High Level AWS Source Configuration

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "redshifLpu",
      "Effect": "Allow",
      "Action": [
        "redshift:DescribeClusters",
        "cloudwatch:GetMetricStatistics",
        "cloudwatch:ListMetrics"
      ],
      "Resource": "*"
    }
  ]
}

Connection Parameters

Name	Required?	Description
Access Key ID	Required
Secret Access Key	Required
Region
Cluster IDs
Cluster Tags
Period

Metrics

Cluster

Name	Description
Allow Version Upgrade	A Boolean value that, if true, indicates that major version upgrades will be applied automatically to the cluster during the maintenance window.
Automated Snapshot Retention Period (Days)	The number of days that automatic cluster snapshots are retained.
Availability Zone	The name of the Availability Zone in which the cluster is located.
Cluster Endpoint	The endpoint of the cluster.
Cluster Identifier	The unique identifier of the cluster.
Cluster Status	The current state of the cluster.
Cluster Tags	The list of tags for the cluster.
CPU Utilization (%)	The percentage of CPU utilization
Create Time	The date and time that the cluster was created.
Database Connections (Connections)	The number of database connections to a cluster.
Disk Space Utilization (%)	The percent of disk space used.
Encrypted	A Boolean value that, if true, indicates that data in the cluster is encrypted at rest.
Healthy	Indicates the health of the cluster.
Maintenance Mode	Indicates whether the cluster is in maintenance mode.
Network Receive Throughput (Bytes per Second)	The rate at which the cluster receives data.
Network Transmit Throughput (Bytes per Second)	The rate at which the cluster writes data.
Number Of Compute Nodes	The number of compute nodes in the cluster.
Preferred Maintenance Window	The weekly time range, in Universal Coordinated Time (UTC), during which system maintenance can occur.
Publicly Accessible	A Boolean value that, if true, indicates that the cluster can be accessed from a public network.
Read IO Rate (Operations per Second)	The average number of disk read operations per second across all nodes.
Read Latency (Seconds)	The average amount of time taken for disk read I/O operations across all nodes.
Read Throughput (Bytes per Second)	The average number of bytes read from disk per second across all nodes.
Region	The AWS Region this object belongs to.
Revision Number	The specific revision number of the database in the cluster.
Subnet Group Name	The name of the subnet group that is associated with the cluster.
Version	The version ID of the Amazon Redshift engine that is running on the cluster.
Write IO Rate (Operations per Second)	The average number of write operations per second across all nodes.
Write Latency (Seconds)	The average amount of time taken for disk write I/O operations across all nodes.
Write Throughput (Bytes per Second)	The average number of bytes written to disk per second across all nodes.

Node

Name	Description
CPU Utilization (%)	The percentage of CPU utilization.
Disk Space Utilization (%)	The percent of disk space used.
Network Receive Throughput (Bytes per Second)	The rate at which the node receives data.
Network Transmit Throughput (Bytes per Second)	The rate at which the node transmits data.
Node ID	The ID of the Node.
Node Role	The role of the node.
Private IP Address	The private IP address of a node within a cluster.
Public IP Address	The public IP address of a node within a cluster.
Read IO Rate (Operations per Second)	The average number of disk read operations per second.
Read Latency (Seconds)	The average amount of time taken for disk read I/O operations.
Read Throughput (Bytes per Second)	The average number of bytes read from disk per second.
Region	The AWS Region this object belongs to.
Write IO Rate (Operations per Second)	The average number of write operations per second.
Write Latency (Seconds)	The average amount of time taken for disk write I/O operations.
Write Throughput (Bytes per Second)	The average number of bytes written to disk per second.