Amazon Redshift discovery with Patterns

  • Release version: Xanadu
  • Updated July 31, 2025
  • 1 minute to read

    • 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 Amazon AWS Cloud components discovery using patterns.

    Data collected by Discovery during horizontal discovery

    Discovery populates the data in the CMDB when running the Amazon AWS Redshift pattern.

    Table 1. Amazon Redshift [cmdb_ci_aws_redshift]
    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.
    Table 2. Availability Zone [cmdb_ci_availability_zone]
    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.

    Table 3. Key Value [cmdb_key_value]
    Field Description
    Key [key] Tag name.
    Value [value] Tag value.
    Configuration item [configuration_item] References the Amazon Redshift [cmdb_ci_aws_redshift] table.