AWS Glue Database pattern-based discovery
Summarize
Summary of AWS Glue Database pattern-based discovery
AWS Glue Database pattern-based discovery is a functionality in the Discovery and Service Mapping Patterns application that enables ServiceNow customers to identify AWS Glue Databases within their cloud environments. This discovery populates data into both CMDB and non-CMDB tables, providing comprehensive visibility into Glue Database resources and their attributes.
Show less
Key Features
- Pattern Activation: The AWS Glue Database discovery pattern is disabled by default. Starting with Visibility Content version 6.28.0, enabling or disabling patterns does not count as a customization, ensuring updates continue smoothly. After upgrading, patterns reset to the latest predefined version while keeping the last active state.
- Prerequisites and Resource Management: Before running discovery, verify AWS discovery prerequisites and ensure the Glue Database resource is not listed in the Resource Inclusion List to prevent duplicate discovery.
- Data Storage: The discovery populates detailed information into both CMDB and non-CMDB tables:
- Non-CMDB Table [cmdbawsgluedatabase]: Stores Glue database name, ARN (Object ID), Data Catalog ID, location URI, and references to the Cloud Resource table.
- CMDB Table [cmdbcicmpresource]: Stores resource metadata including name, ARN, resource type (set as AWS::Glue::Database), install status (default Installed), and operational status (default Operational).
- CI Relationships and References: The pattern establishes relationships such as "Hosted on" linking Glue databases to AWS datacenters, and references between Glue Database and Cloud Resource records for integrated CMDB visibility.
- Tag Discovery: AWS Glue Database tags are collected and stored in the Key Value [cmdbkeyvalue] table, associating tag names and values with the corresponding Cloud Resource records.
Practical Benefits for ServiceNow Customers
- Gain automated, up-to-date visibility into AWS Glue Database resources within the CMDB and supporting tables.
- Leverage detailed metadata and tagging information to enhance asset management, compliance, and operational insights.
- Maintain accurate resource relationships and status information crucial for service mapping and impact analysis.
- Ensure efficient discovery by managing resource inclusion lists and enabling the correct pattern versions.
Discovery and Service Mapping Patterns finds AWS Glue Databases 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 AWS 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 AWS Resource Inventory discovery with Patterns.
- 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.
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 - Glue Database - Extended Inventory (LP) pattern.
You can review the non-CMDB AWS tables by navigating to . You can also search the navigation filter for the specific pattern name.
| Field | Description |
|---|---|
| Name [name] | Name of the Glue database. |
| Object ID [object_id] | The Amazon Resource Name (ARN) of the Glue database, constructed from the region, account ID, and database name, in the following format:
arn:aws:glue:{region}:{account-id}:database/{database-name}. |
| Catalog ID [catalog_id] | The ID of the Data Catalog in which the database resides. |
| Location Uri [location_uri] | The location of the database, for example an HDFS path. |
| Configuration Item [configuration_item] | References the Cloud Resource [cmdb_ci_cmp_resource] table. |
Data stored in CMDB tables
Discovery and Service Mapping Patterns application populates data in the CMDB when running the Amazon AWS - Glue Database - Extended Inventory (LP) pattern.
| Field | Description |
|---|---|
| Name [name] | Name of the Glue database. |
| Object ID [object_id] | The ARN of the Glue database, constructed from the region, account ID, and database name, in the following format: arn:aws:glue:{region}:{account-id}:database/{database-name}. |
| Resource type [resource_type] | Type of resource. The value is set to AWS::Glue::Database. |
| 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. |
CI relationships
The Amazon AWS - Glue Database - Extended Inventory (LP) pattern creates the following relationships and references to support AWS Glue Database discovery. References link to records in other tables and don't appear in the CI Relationship [cmdb_rel_ci] table.
| CI | Relationship | CI |
|---|---|---|
| Cloud Resource [cmdb_ci_cmp_resource] | Hosted on::Hosts | AWS Datacenter [cmdb_ci_aws_datacenter] |
| CI | Field | Referenced CI |
|---|---|---|
| AWS Glue Database [cmdb_aws_glue_database] | Configuration Item [configuration_item] | Cloud Resource [cmdb_ci_cmp_resource] |
| Key Value [cmdb_key_value] | Configuration item [configuration_item] | Cloud Resource [cmdb_ci_cmp_resource] |
AWS Tag discovery
The Amazon AWS - Glue Database - Extended Inventory (LP) 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 Cloud Resource [cmdb_ci_cmp_resource] table. |