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 identify and map AWS Glue Databases within their cloud environment using Discovery and Service Mapping Patterns. This functionality helps populate configuration management databases (CMDB) and non-CMDB tables with detailed information about the Glue databases, supporting effective cloud resource management and visibility.
Show less
Key Features
- Pattern Activation: The AWS Glue Database discovery pattern is disabled by default. Customers must enable it, especially when using Visibility Content version 6.28.0 or later, where pattern activation is no longer treated as a customization and patterns update automatically after upgrades.
- Prerequisites: Requires meeting AWS discovery prerequisites and ensuring the Glue Database resource is not listed in the Resource Inclusion List table to prevent duplicate discovery.
- Data Population: Runs the Amazon AWS - Glue Database - Extended Inventory (LP) pattern to populate data in both CMDB and non-CMDB tables, offering comprehensive resource details.
- CMDB Integration: Discovered Glue databases are recorded in the Cloud Resource [cmdbcicmpresource] table with attributes such as name, ARN (Object ID), resource type (AWS::Glue::Database), install status, and operational status.
- Non-CMDB Data Storage: Additional Glue database details like catalog ID and location URI are stored in the AWS Glue Database [cmdbawsgluedatabase] non-CMDB table.
- CI Relationships and References: The pattern establishes relationships, such as linking Glue databases to AWS datacenters, and maintains references between CMDB and non-CMDB tables for data consistency.
- AWS Tag Discovery: Captures AWS tags associated with Glue databases and stores them in the Key Value [cmdbkeyvalue] table, linking tags to their corresponding cloud resources.
What Customers Can Expect
- Automated discovery and inventory of AWS Glue Databases integrated into the ServiceNow CMDB, enhancing cloud asset visibility and management.
- Accurate and up-to-date resource details including ARNs, catalog IDs, and locations, enabling better tracking and governance of AWS Glue resources.
- Seamless maintenance of relationships between Glue databases and AWS infrastructure components for comprehensive service mapping.
- Effective management of AWS resource tags within ServiceNow, facilitating categorization, reporting, and automation based on tags.
- Reduced risk of duplicate resource discovery by managing the Resource Inclusion List appropriately.
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. |