• /
  • Log in

Amazon Redshift integration

New Relic infrastructure integrations 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

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 One.

Activate integration

To enable this integration, follow standard procedures to Connect AWS services to New Relic.

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 Amazon RedShift integration:

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

Find and use data

To find your integration data, go to one.newrelic.com > Infrastructure > AWS and select one of the Redshift integration links.

You can query and explore your data using 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 Amazon 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 data

The integration collects inventory data 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 data

The integration collects inventory data 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 data

The integration collects inventory data 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

If you need more help, check out these support and learning resources:

Create issueEdit page
Copyright © 2021 New Relic Inc.