--- title: Amazon Redshift integration source: https://docs.newrelic.com/docs/infrastructure/amazon-integrations/aws-integrations-list/aws-redshift-integration --- > #### ⚠️ IMPORTANT > > Enable the [AWS CloudWatch Metric Streams integration](https://docs.newrelic.com/docs/infrastructure/amazon-integrations/aws-integrations-list/aws-metric-stream/) to monitor all CloudWatch metrics from your AWS services, including custom namespaces. Individual integrations are no longer our recommended option. [New Relic infrastructure integrations](https://docs.newrelic.com/docs/infrastructure/introduction-infra-monitoring) include an integration for reporting your Amazon Redshift data to New Relic. This document explains how to activate the integration and describes the data reported. ## Features [#features] [Amazon Redshift](https://aws.amazon.com/redshift) is a fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Amazon Business Intelligence (BI) tools. New Relic's Redshift integration gathers metric and configuration data for the relational databases associated with your Amazon Redshift account. Reported data includes bytes received and bytes transmitted, health status, database connections, latency, and other [metrics](#metrics)). Your Redshift data is available in pre-built dashboards and you can also create [custom queries and charts](https://docs.newrelic.com/docs/infrastructure/integrations-getting-started/getting-started/use-integration-data-new-relic-insights). ## Activate integration [#activate] To enable this integration, follow standard procedures to [Connect AWS services to New Relic](https://docs.newrelic.com/docs/infrastructure/infrastructure-integrations/getting-started/connect-aws-integrations-infrastructure). To allow New Relic to access Redshift data, your AWS account must have the **ReadOnly** policy associated with it, or the following permissions must be granted to your New Relic account: - `describeClusters` - `describeClusterParameters` ## Configuration and polling [#polling] You can change the polling frequency and filter data using [configuration options](https://docs.newrelic.com/docs/integrations/new-relic-integrations/getting-started/configure-polling-frequency-data-collection-cloud-integrations). Default [polling](https://docs.newrelic.com/docs/infrastructure/amazon-integrations/aws-integrations-list/aws-polling-intervals-infrastructure-integrations) information for the Amazon RedShift integration: - New Relic polling interval: 5 minutes - Amazon CloudWatch data interval: 1 minute ## Find and use data [#find-data] To find your integration data, go to **[one.newrelic.com > All capabilities](https://one.newrelic.com/all-capabilities) > Infrastructure > AWS** and select one of the Redshift integration links. You can [query and explore your data](https://docs.newrelic.com/docs/using-new-relic/data/understand-data/query-new-relic-data) using the `DatastoreSample` [event type](https://docs.newrelic.com/docs/data-apis/understand-data/new-relic-data-types/#event-data), with a `provider` value of `RedshiftNode` for Redshift nodes, or `RedshiftCluster` for Redshift clusters. For more on how to use your data, see [Understand and use integration data](https://docs.newrelic.com/docs/infrastructure/integrations/find-use-infrastructure-integration-data). ## Metric data [#metrics] New Relic collects the following Amazon Redshift data. For full descriptions of each metric, see Amazon's [Redshift documentation](http://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/rs-metricscollected.html). | Name | Data type | Dimension | | ------------------------------ | ------------------------------------------------------------ | ------------------------------ | | `CPUUtilization` | percent | `NodeID, ClusterIdentifier` | | `DatabaseConnections` | count | `ClusterIdentifier` | | `HealthStatus` | 1/0 (`HEALTHY`/`UNHEALTHY` in the Amazon CloudWatch console) | `ClusterIdentifier` | | `MaintenanceMode` | 1/0 (`ON`/`OFF` in the Amazon CloudWatch console) | `ClusterIdentifier` | | `NetworkReceiveThroughput` | bytes/seconds (`MB/s` in the Amazon CloudWatch console) | `NodeID`, `ClusterIdentifier` | | `NetworkTransmitThroughput` | bytes/seconds (`MB/s` in the Amazon CloudWatch console) | `NodeID`, `ClusterIdentifier` | | `PercentageDiskSpaceUsed` | percent | `NodeID`, `ClusterIdentifier` | | `QueriesCompletedPerSecond` | count/second (for multi-node clusters) | `latency`, `ClusterIdentifier` | | `QueryDuration` | microseconds (for multi-node clusters) | `latency`, `ClusterIdentifier` | | `ReadIOPS` | count/second | `NodeID`, `ClusterIdentifier` | | `ReadLatency` | seconds | `NodeID` | | `ReadThroughput` | bytes (`GB/s` in the Amazon CloudWatch console) | `NodeID` | | `WLMQueriesCompletedPerSecond` | count/second (for multi-node clusters) | `ClusterIdentifier` | | `WLMQueryDuration` | Microseconds (for multi-node clusters) | `ClusterIdentifier` | | `WriteIOPS` | count/seconds | `NodeID` | | `WriteLatency` | seconds | `NodeID` | | `WriteThroughput` | bytes (`GB/s` in the Amazon CloudWatch console) | `NodeID` | ## Dimensions Amazon Redshift metrics [#dimensions] Amazon Redshift data can be filtered along any of the following [dimensions](http://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/rs-metricscollected.html#rs-metric-dimensions): | Dimension | Description | | ------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `NodeID` | Filters requested data that is specific to the nodes of a cluster. `NodeID` will be either `Leader`, `Shared`, or `Compute-N`, where `N` is 0, 1, etc. for the number of nodes in the cluster. `Shared` means that the cluster has only one node. The `Leader` node and `Compute` node are combined. | | `ClusterIdentifier` | Filters requested data that is specific to the cluster. Metrics that are specific to clusters include `HealthStatus`, `MaintenanceMode`, and `DatabaseConnections`. In general, metrics for this dimension (for example, `ReadIOPS`) that are also metrics of nodes represent an aggregate of the node metric data. Take care in interpreting these metrics, because they aggregate behavior of `Leader` and `Compute` nodes. |