cmdb_ot_entity_type<\/code>, ServiceNow object: OT Asset Sort.<\/li>\n\n <\/ol>\nArrange and run AWS Glue Crawler to determine the schema<\/strong><\/p>\n\n- Navigate to AWS Glue console.<\/li>\n
- Within the left menu, underneath Knowledge Catalog<\/strong>, select Crawlers<\/strong>.<\/li>\n
- Within the Crawlers<\/strong> dialog field, see Determine 6, select Create crawler<\/strong>.<\/li>\n<\/ol>\n
![\"AWS](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_6_AWS-Glue-crawlers.png\")
<\/p>\n
Determine 6: AWS Glue crawlers<\/p>\n
\n- For Crawler title<\/strong>, use ServiceNow Crawler<\/strong> and select Subsequent<\/strong>.<\/li>\n<\/ol>\n
![\"Crawler](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_7_Crawler-properties.png\")
<\/p>\n
Determine 7: Crawler properties<\/p>\n
\n- Select Add an information supply<\/strong>.<\/li>\n
- Within the Add knowledge supply <\/strong>dialog field, see Determine 8, enter the next:\n
\n- For Knowledge supply<\/strong>, select S3<\/strong>.<\/li>\n
- For S3 path<\/strong>, select
<your_bucket_name><\/code>.<\/li>\n- Choose Add an S3 knowledge supply<\/strong>.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
![\"Crawler](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_8_Crawler-data-source-777x1024.png\")
Determine 8: Crawler knowledge supply<\/p>\n
\n- Select Subsequent<\/strong>.<\/li>\n
- Underneath IAM function, choose Create new IAM function, <\/strong>see Determine 9.<\/li>\n<\/ol>\n
![\"Crawler](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_9_Crawler-IAM-Role.png\")
<\/p>\n
Determine 9: Crawler IAM Position<\/p>\n
\n- Select a reputation for the function. On this instance, we use
AWSGlueServiceRole-ServiceNowCrawler<\/code>.<\/li>\n- Choose Subsequent.<\/strong><\/li>\n
- Underneath Goal database, select an AWS Glue Database. This instance makes use of the default database.<\/li>\n<\/ol>\n
![\"AWS](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_10_AWS-Glue-Database-Selection.png\")
<\/p>\n
Determine 10: AWS Glue Database Choice<\/p>\n
\n- Select Subsequent<\/strong>.<\/li>\n
- Select Create<\/strong>.<\/li>\n
- Run the crawler. It ought to take round two minutes to finish.<\/li>\n<\/ol>\n
The ServiceNow parquet knowledge has now been efficiently imported into Amazon S3.<\/p>\n
<\/span>Remodel the JSON information<\/span><\/h3>\nOn this part, you’ll arrange the AWS Glue job to rework the parquet information to JSON format appropriate for AWS IoT SiteWise and import the info into AWS IoT SiteWise.<\/p>\n
Create AWS Glue Job<\/strong><\/p>\n\n- Navigate to AWS Glue console.<\/li>\n
- Within the menu to the left, underneath ETL Jobs<\/strong>, select Visible ETL.<\/strong><\/li>\n
- In Create Job<\/strong>, choose Visible ETL.<\/strong><\/li>\n<\/ol>\n
![\"AWS](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_11_AWS-Glue-studio.png\")
<\/p>\n
Determine 11: AWS Glue studio<\/p>\n
\n- Create a Supply node. Choose the blue plus (+) button, see Determine 12, and choose Amazon S3<\/strong>.<\/li>\n<\/ol>\n
![\"Visual](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_12_Visual-ETL.png\")
<\/p>\n
Determine 12: Visible ETL<\/p>\n
\n- For Title<\/strong>, select any title for the node, see Determine 13. On this instance, we are going to use cmdb_ot_entity.<\/li>\n
- For S3 supply kind<\/strong>, choose Knowledge Catalog desk<\/strong>.<\/li>\n
- For Database, <\/strong>select the goal database you beforehand chosen when organising your AWS Glue Crawler.<\/li>\n
- For Desk<\/strong>, select the primary desk
cmbd_ot_entity<\/code>. Repeat this step for every of the tables: cmdb_ci_ot<\/code> and cmdb_ot_entity_type<\/code>.<\/li>\n<\/ol>\n![\"Adding](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_13_Adding-source-node.png\")
<\/p>\n
Determine 13: Including supply node<\/p>\n
Map property to the AWS IoT SiteWise import format<\/strong><\/p>\n\n- Create a brand new Supply node by deciding on the blue \u201c+\u201d button as proven in Determine 12.<\/li>\n
- Add a Remodel<\/strong> node and choose SQL Question<\/strong>.<\/li>\n
- For Title<\/strong>, use \u201cproperty\u201d<\/strong>.<\/li>\n
- For Node dad and mom<\/strong>, select the supply nodes
cmdb_ot_entity<\/code> and cmdb_ci_ot<\/code>.<\/li>\n- For Enter sources and SQL Aliases, select
cmdb_ot_entity<\/code> and cmdb_ci_ot<\/code> for every, as proven in Determine 14.<\/li>\n<\/ol>\n![\"assets](\"https:\/\/d2908q01vomqb2.cloudfront.net\/f6e1126cedebf23e1463aee73f9df08783640400\/2025\/05\/21\/IOTB-835_14_assets-transform.png\")
<\/p>\n
Determine 14: property remodel<\/p>\n
\n- For SQL Question<\/strong>, copy and paste the next question:<\/li>\n<\/ol>\n
\n
\n
SELECT DISTINCT\n mother or father.sys_id as assetExternalId,\n mother or father.title as assetName,\n mother or father.ot_asset_type as assetModelExternalId,\n COLLECT_LIST(\n CASE \n WHEN baby.sys_id IS NOT NULL THEN \n STRUCT(\n array_join(array(mother or father.ot_asset_type, baby.ot_asset_type), '-') as externalId,\n baby.sys_id as childAssetExternalId\n )\n END\n ) as assetHierarchies,\n (\n CASE \n WHEN ot.sys_id IS NOT NULL THEN \n array(\n STRUCT('title' as externalId, ot.title as attributeValue),\n STRUCT('serial_number' as externalId, ot.serial_number as attributeValue),\n STRUCT('producer' as externalId, ot.producer as attributeValue),\n STRUCT('model_number' as externalId, ot.model_number as attributeValue),\n STRUCT('firmware_version' as externalId, ot.firmware_version as attributeValue),\n STRUCT('hardware_version' as externalId, ot.hardware_version as attributeValue),\n STRUCT('asset_tag' as externalId, ot.asset_tag as attributeValue),\n STRUCT('class' as externalId, ot.class as attributeValue),\n STRUCT('atmosphere' as externalId, ot.atmosphere as attributeValue),\n STRUCT('short_description' as externalId, ot.short_description as attributeValue)\n )\n ELSE array()\n END\n ) as assetProperties\nFROM cmdb_ot_entity as mother or father\nLEFT JOIN cmdb_ci_ot as ot\n ON mother or father.ot_asset = ot.sys_id\nLEFT JOIN cmdb_ot_entity as baby\n ON mother or father.sys_id = baby.mother or father\nGROUP BY mother or father.sys_id, mother or father.title, mother or father.ot_asset_type, ot.sys_id, ot.title, ot.serial_number, ot.producer, ot.model_number, ot.firmware_version, ot.hardware_version, ot.asset_tag, ot.class, ot.atmosphere, ot.short_description<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n