Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data.
Enable this integration to see all your Redshift metrics in Datadog.
If you haven’t already, set up the Amazon Web Services integration first.
In the AWS integration tile, ensure that Redshift is checked under metric collection.
Add these permissions to your Datadog IAM policy in order to collect Amazon Redshift metrics:
redshift:DescribeClusters: List all Redshift Clusters in your account.redshift:DescribeLoggingStatus: Get S3 bucket where Redshift logs are stored.tag:GetResources: Get custom tags on your Redshift cluters.For more information on Redshift policies, review the documentation on the AWS website.
Install the Datadog - AWS Redshift integration.
Enable the logging on your Redshift Cluster first to collect your logs. Redshift logs can be written to an AWS S3 bucket and consumed by a Lambda function. For more information, refer to the AWS documentation
Once the lambda function is installed, there are two ways to collect your Redshift logs:
Object Created (All) then click on the add button.Once done, go in your Datadog Log section to start exploring your logs!
| aws.redshift.cpuutilization (gauge) | The percentage of CPU utilization. For clusters, this metric represents an aggregation of all nodes (leader and compute) CPU utilization values. Shown as percent |
| aws.redshift.database_connections (gauge) | The number of database connections to a cluster. Shown as connection |
| aws.redshift.health_status (gauge) | Indicates the health of the cluster. 1 indicates healthy, and 0 indicates unhealthy. |
| aws.redshift.maintenance_mode (gauge) | Indicates whether the cluster is in maintenance mode. 1 indicates on, and 0 indicates off. |
| aws.redshift.network_receive_throughput (rate) | The rate at which the node or cluster receives data. Shown as byte |
| aws.redshift.network_transmit_throughput (rate) | The rate at which the node or cluster writes data. Shown as byte |
| aws.redshift.percentage_disk_space_used (gauge) | The percent of disk space used. Shown as percent |
| aws.redshift.read_iops (rate) | The average number of disk read operations per second. Shown as operation |
| aws.redshift.read_latency (gauge) | The average amount of time taken for disk read I/O operations. Shown as second |
| aws.redshift.read_throughput (rate) | The average number of bytes read from disk per second. Shown as byte |
| aws.redshift.write_iops (rate) | The average number of write operations per second. Shown as operation |
| aws.redshift.write_latency (gauge) | The average amount of time taken for disk write I/O operations. Shown as second |
| aws.redshift.write_throughput (rate) | The average number of bytes written to disk per second. Shown as byte |
Each of the metrics retrieved from AWS will be assigned the same tags that appear in the AWS console, including but not limited to host name, security-groups, and more.
The AWS Redshift integration does not include any events.
The AWS Redshift integration does not include any service checks.
Need help? Contact Datadog support.
