Amazon Redshift discovery with Patterns
The ServiceNow® Discovery application uses the Amazon AWS Redshift pattern to find Redshift data warehouse services available on Amazon Web Services (AWS). Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.
Redshift runs as a cluster of compute nodes with an additional leader node. The leader node acts as an interface with client applications and coordinates communication between the compute nodes.
Pattern-based discovery and mapping requirements
Verify the AWS discovery prerequisites section in AWS discovery using patterns.
Data collected by Discovery during horizontal discovery
Discovery populates the data in the CMDB when running the Amazon AWS Redshift pattern.
| Field | Description |
|---|---|
| Name \[name\] | Name of the Redshift cluster. |
| Object ID \[object\_id\] | A unique identifier constructed from the Redshift namespace Amazon Resource Name (ARN) and the cluster name in the following format: arn:aws:redshift:<region>:<account-id>:cluster:<cluster-name>. |
| Start date \[start\_date\] | Timestamp when the Redshift cluster was created. |
| Cluster Availability Status \[cluster\_availability\_status\] | Current availability status of the Redshift cluster.For example: Available, Unavailable, or Maintenance. |
| VPC ID \[vpc\_id\] | ID of the virtual private cloud \(VPC\) in which the Redshift cluster is deployed. |
| Node Count \[node\_count\] | Total number of compute nodes in the Redshift cluster. |
| Node Type \[node\_type\] | Type of compute nodes used in the Redshift cluster. |
| Fully qualified domain name \[fqdn\] | Fully qualified domain name \(FQDN\) of the Redshift cluster endpoint. |
| TCP port\(s\) \[tcp\_port\] | TCP port used by the Redshift cluster for client connections. |
| IP Address \[ip\_address\] | IP address associated with the Redshift cluster endpoint. |
| Availability Zone \[availability\_zone\] | References the Availability Zone \[cmdb\_ci\_availability\_zone\] table. |
| Field | Description |
|---|---|
| Name [name] | Name of the avaiability zone. |
| Object ID [object_id] | Name of the avaiability zone. |
CI relationships
Discovery creates these relationships to support the Amazon Redshift discovery.
| CI | Relationship | CI |
|---|---|---|
| Amazon Redshift [cmdb_ci_aws_redshift] | References | Availability Zone [cmdb_ci_availability_zone] |
| AWS Datacenter [cmdb_ci_aws_datacenter] | Contains::Contained by | Availability Zone [cmdb_ci_availability_zone] |
| Key Value [cmdb_key_value] | References | Amazon Redshift [cmdb_ci_aws_redshift] |
Tag discovery
The Amazon AWS Redshift pattern collects tags and populates them in the Key Value [cmdb_key_value] table.
| Field | Description |
|---|---|
| Key [key] | Tag name. |
| Value [value] | Tag value. |
| Configuration item [configuration_item] | References the Amazon Redshift [cmdb_ci_aws_redshift] table. |
Parent Topic:AWS discovery using patterns