AWS Glue Database pattern-based discovery
Summarize
Summary of AWS Glue Database pattern-based discovery
The AWS Glue Database pattern-based discovery enables ServiceNow customers to discover and map AWS Glue Databases within their cloud environments using Discovery and Service Mapping Patterns. This capability helps populate data both in CMDB and non-CMDB tables, providing comprehensive insight into AWS Glue Database resources.
Show less
Prerequisites and Setup
- Verify AWS discovery prerequisites as outlined in the Amazon AWS Cloud components discovery documentation.
- Ensure that the Glue Database resource is not listed in the Resource Inclusion List [sacloudinventoryresourcewhitelist] to prevent duplicate discovery.
- The AWS Glue Database pattern is disabled by default; it must be enabled manually. Starting with Visibility Content version 6.28.0, enabling or disabling patterns is no longer considered a customization and updates will continue to apply after upgrades.
- Keep the Discovery and Service Mapping Patterns application updated via the ServiceNow Store to ensure compatibility.
Data Storage and Tables
Discovery results are stored in both CMDB and non-CMDB tables:
- Non-CMDB Tables: Data from the "Amazon AWS - Glue Database - Extended Inventory (LP)" pattern is stored in non-CMDB AWS tables, accessible under All > Configuration > AWS. Key fields include the Glue database name, ARN (Amazon Resource Name), catalog ID, location URI, and a reference to the configuration item.
- CMDB Tables: The same pattern populates the Cloud Resource [cmdbcicmpresource] table with details such as resource name, ARN, resource type (set as AWS::Glue::Database), install status, and operational status.
CI Relationships and References
- The pattern creates CI relationships to represent hosting, linking AWS Glue Database CIs to AWS Datacenter CIs.
- References connect Glue Database records to Cloud Resource and Key Value tables but do not appear in the CI Relationship table.
AWS Tag Discovery
The pattern collects AWS tags associated with Glue Databases and stores them in the Key Value [cmdbkeyvalue] table, linking each tag name and value to the corresponding Cloud Resource record. This enables tagging metadata to be leveraged within ServiceNow.
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 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.
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. |