Amazon Redshift Serverless Workgroup pattern-based discovery

  • Release version: Xanadu
  • Updated June 16, 2026
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Amazon Redshift Serverless Workgroup pattern-based discovery

    The Amazon Redshift Serverless Workgroup pattern-based discovery in ServiceNow enables automated identification and mapping of Redshift Serverless workgroups within your AWS cloud environment. This discovery populates critical configuration data into both CMDB and non-CMDB tables, helping you maintain an accurate and up-to-date asset inventory for effective cloud management.

    Show full answer Show less

    Key Features

    • Pattern Activation: The Redshift Serverless Workgroup discovery pattern is disabled by default. From Visibility Content version 6.28.0 onward, enabling or disabling this pattern does not count as customization and patterns reset to the latest version after upgrades while retaining active status.
    • AWS Prerequisites: Ensure AWS discovery prerequisites are met and the relevant resources are not listed in the Resource Inclusion List to avoid duplicate discoveries.
    • Support for AWS GovCloud: When discovering AWS GovCloud (US) accounts, configure the discovery schedule to use the appropriate datacenter URL.
    • Data Population: Discovery populates detailed data into:
      • Non-CMDB tables, such as cmdbawsredshiftserverlessworkgroup, capturing fields like ARN (objectid), name, status, and workgroup ID.
      • CMDB tables, primarily cmdbciclouddatabase, with install status, operational status, type, and references to the discovered workgroups.
    • Configuration Item Relationships: The pattern establishes CI relationships linking Redshift Serverless workgroups to AWS datacenters and cloud databases, enabling comprehensive service mapping.
    • AWS Tag Discovery: Tags associated with Redshift Serverless workgroups are collected and stored in the cmdbkeyvalue table, facilitating tag-based filtering and reporting.

    Practical Considerations for ServiceNow Customers

    • Activate the Pattern: To discover Redshift Serverless workgroups, enable the pattern in your Discovery and Service Mapping Patterns application. This ensures your CMDB reflects current Redshift Serverless resources.
    • Avoid Duplicate Entries: Verify that Redshift Serverless resources are not included in the Resource Inclusion List to prevent duplicate discovery records.
    • Use Updated Discovery Application: Make sure you run the latest Discovery and Service Mapping Patterns app version from the ServiceNow Store to fully support Redshift Serverless discovery.
    • Review Discovered Data: Use the ServiceNow CMDB and AWS-specific non-CMDB tables to analyze discovered resources and their relationships, supporting asset management and operational decision-making.
    • Leverage Tag Data: Utilize collected AWS tags for enhanced categorization and governance of your Redshift Serverless workgroups.

    Discovery and Service Mapping Patterns finds AWS services on your cloud environment. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

    Pattern-based discovery and mapping requirements

    Verify the AWS discovery prerequisites
    For more information, see the prerequisites section in Amazon AWS Cloud components discovery using patterns.
    Remove resources from the Resource Inclusion List table
    Verify that the relevant resource isn't listed in the Resource Inclusion List [sa_cloud_inventory_resource_whitelist] table to avoid duplicate discovery. For more information on removing resources from the Resource Inclusion List, see Amazon Web Services (AWS) Resource Inventory.
    Enable the relevant pattern
    The pattern for this service is disabled by default. Starting with Visibility Content version 6.28.0, activating or deactivating a pattern won't be considered a customization, and it will continue to receive updates. Patterns that were previously activated or deactivated will reset to the latest predefined version after upgrading while retaining the last active field value. For more information on enabling patterns, see Activate a disabled pattern.
    Configure the Discovery schedule to support GovCloud
    Discovering AWS GovCloud (US) accounts requires using a datacenter URL when setting up an AWS service account. For more information, see Create AWS service accounts.

    Discovery and Service Mapping Patterns application populates data in both CMDB and non-CMDB tables.

    Data stored in non-CMDB tables

    Discovery and Service Mapping Patterns application populates data in the non-CMDB table when running the Amazon AWS - Redshift Serverless Workgroup - Extended Inventory (LP) pattern.

    You can review the non-CMDB AWS tables by navigating to All > Configuration > AWS. You can also search the navigation filter for the specific pattern name.

    Table 1. AWS Redshift Serverless - Workgroup [cmdb_aws_redshift_serverless_workgroup]
    Field Description
    Object Id [object_id] The Amazon Resource Name (ARN) that uniquely identifies the resource.
    Name [name] The name assigned to the resource or workgroup.
    Status [status] The current operational status of the resource or workgroup.
    Configuration Item [configuration_item] References the Cloud DataBase [cmdb_ci_cloud_database] table.
    Workgroup ID [workgroup_id] The unique identifier for the Redshift Serverless workgroup.

    Data stored in CMDB tables

    Discovery and Service Mapping Patterns application populates data in the CMDB when running the Amazon AWS - Redshift Serverless Workgroup - Extended Inventory (LP) pattern.

    Table 2. Cloud DataBase [cmdb_ci_cloud_database]
    Field Description
    Object ID [object_id] The ARN that uniquely identifies the resource.
    Name [name] The name assigned to the resource or workgroup.
    Install Status [install_status] Install status of the resource. Default value is Installed.
    Operational status [operational_status] Operational status of the resource. Default value is Operational.
    Type [type] Type of resource. The value is set to AWS::Redshift Serverless::Workgroup.

    CI relationships

    The Amazon AWS - Redshift Serverless Workgroup - Extended Inventory (LP) pattern creates these relationships to support Amazon Redshift Serverless Workgroup discovery.

    CI Relationship CI
    Cloud DataBase [cmdb_ci_cloud_database] Hosted on::Hosts AWS Datacenter [cmdb_ci_aws_datacenter]
    AWS Redshift Serverless - Workgroup [cmdb_aws_redshift_serverless_workgroup] References Cloud DataBase [cmdb_ci_cloud_database]

    AWS tag discovery

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