Overview

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.

Setup

Installation

If you haven’t already, set up the Amazon Web Services integration first.

Metric collection

1. In the AWS integration page, ensure that Redshift is enabled under the Metric Collection tab.

2. 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 clusters.

   For more information, see the Redshift policies on the AWS website.

3. Install the Datadog - Amazon Redshift integration.

Log collection

Enable logging

Enable the logging on your Redshift Cluster first to collect your logs. Redshift logs can be written to an Amazon S3 bucket and consumed by a Lambda function. For more information, see Configuring auditing using the console.

Send logs to Datadog

1. If you haven’t already, set up the Datadog Forwarder Lambda function in your AWS account.

2. Once the Lambda function is installed, there are two ways to collect your Redshift logs:

   • Automatically: Redshift logs are managed automatically if you grant Datadog access with a set of permissions. See Automatically Set Up Triggers for more information on configuring automatic log collection on the Datadog Forwarder Lambda function.
   • Manually: In the AWS console, add a trigger on the S3 bucket that contains your Redshift logs. See the manual installation steps.

Manual installation steps

1. If you haven’t already, set up the Datadog Forwarder Lambda function in your AWS account.
2. Once set up, go to the Datadog Forwarder Lambda function. In the Function Overview section, click Add Trigger.
3. Select the S3 trigger for the Trigger Configuration.
4. Select the S3 bucket that contains your Redshift logs.
5. Leave the event type as All object create events.
6. Click Add to add the trigger to your Lambda.

Go to the Log Explorer to start exploring your logs.

For more information on collecting AWS Services logs, see Send AWS Services Logs with the Datadog Lambda Function.

Data Collected

Metrics

See metric-spec.yaml for a list of metrics provided by this integration.

Each of the metrics retrieved from AWS are assigned the same tags that appear in the AWS console, including but not limited to host name, security-groups, and more.

Events

The Amazon Redshift integration does not include any events.

Service Checks

The Amazon Redshift integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.