AWS Redshift integration

Access to this feature depends on your subscription level. Requires Infrastructure Pro.

New Relic Infrastructure's integrations include an integration for reporting your AWS Redshift data to New Relic products. This document explains how to activate the integration and describes the data reported.

Features

Amazon 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 and configuration data. Your Redshift data is available in pre-built dashboards and you can also create custom queries and charts in New Relic Insights.

Activate integration

To enable this integration:

  1. Make sure you have installed the Infrastructure agent before you activate AWS integrations from your Infrastructure account.
  2. Follow standard procedures to Connect AWS services to 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

You can change the polling frequency and filter data using configuration options.

Default polling information for the AWS RedShift integration:

  • New Relic polling interval: 5 minutes
  • Amazon CloudWatch data interval: 1 minute

Find and use data

To find your integration data in Infrastructure, go to infrastructure.newrelic.com > Integrations > Amazon Web Services and select one of the Redshift integration links.

In New Relic Insights, data is attached to the DatastoreSample event type, with a provider value of RedshiftSample.

For more on how to use your data, see Understand and use integration data.

Metric data

New Relic collects the following AWS Redshift data. For full descriptions of each metric, see Amazon's Redshift documentation.

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

Inventory data

New Relic Infrastructure's Redshift integration includes three inventory objects:

For more about inventory data, see Understand integration data.

Cluster attributes

Integrations collects these inventory attributes from aws/elasticsearch/cluster/config. For detailed descriptions, see Amazon's Redshift documentation for clusters.

Name Data type
allowVersionUpgrade boolean
automatedSnapshotRetentionPeriod integer
availabilityZone string
awsRegion string
clusterIdentifier string
clusterSecurityGroups list
clusterStatus string
clusterVersion string
dbName string
encrypted boolean
endpoint structure
enhancedVpcRouting boolean
masterUsername string
nodeType string
numberOfNodes integer
preferredMaintenanceWindow string
publiclyAccessible boolean

ClusterParameters attributes

Integrations collects these inventory attributes from aws/redshift/cluster/clusterParameters/. For detailed descriptions, see Amazon's Redshift documentation for default parameter values.

Name Value
datestyle ISO, MDY
enable_user_activity_logging false
extra_float_digits 0
max_cursor_result_set_size Deprecated
query_group default
require_ssl false
search_path $user, public
statement_timeout 0
wlm_json_configuration [{"query_concurrency":5}]

Node attributes

Integrations collects these inventory attributes from aws/redshift/node/. For detailed descriptions, see Amazon's Redshift documentation for cluster nodes.

Name Data type
awsRegion string
clusterId string
nodeId string
privateIpAddress string
publicIpAddress string

Dimensions Amazon Redshift metrics

Amazon Redshift data can be filtered along any of the following 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.

For more help

Recommendations for learning more: