To answer business questions in manufacturing, supply chain, and other domains, customers often need to combine Information Technology (IT) data with Operational Technology (OT) data. This means comb...
Updated Jul 13, 2022
Version 5.0
Blog Post
7 MIN READ
Integrating IT and OT Data with Azure Digital Twins, Azure Data Explorer, and Azure Synapse
Hi sureshshanmugam,
Thank you for for reaching out. To answer your question, I'll reference an example twin graph provided in the blog Rewind the Metaverse with Data History for Azure Digital Twins.
You can write a query that traverses the graph across specific relationships as follows:
SELECT location, factory, operator, machine FROM DIGITALTWINS
MATCH (location)-[:contains]->(factory)-[:employs]->(operator)-[:maintains]->(machine)
WHERE location.$dtId = 'Norway'
Running this query in PS with the $ escaped as `$:
PS C:\Users\taanderson> az dt twin query -n <ADTinstance> -q "SELECT location, factory, operator, machine FROM DIGITALTWINS MATCH (location)-[:contains]->(factory)-[:employs]->(operator)-[:maintains]->(machine) WHERE location.`$dtId = 'Norway'"
{
"result": [
{
"factory": {
"$dtId": "OsloFactory",
"$etag": "W/\"00246fff-cb8f-4813-bd5d-c5bc4baf89d3\"",
"$metadata": {
"$model": "dtmi:assetGen:Factory;1"
}
},
"location": {
"$dtId": "Norway",
"$etag": "W/\"02f1ec81-60ab-4620-832c-882d3e906e3b\"",
"$metadata": {
"$model": "dtmi:assetGen:Country;1"
}
},
"machine": {
"$dtId": "PasteurizationMachine_A01",
"$etag": "W/\"02d370e9-3b22-4083-a72a-e748e216cf7f\"",
"$metadata": {
"$model": "dtmi:assetGen:PasteurizationMachine;1",
"InFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.6085611Z"
},
"OutFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.6085611Z"
},
"PercentFull": {
"lastUpdateTime": "2022-05-23T18:04:01.6085611Z"
},
"Temperature": {
"lastUpdateTime": "2022-05-23T18:04:01.6085611Z"
}
},
"InFlow": 575.7868690625321,
"OutFlow": 140.15760634346958,
"PercentFull": 0.8269335486119614,
"Temperature": 121.78687129239059
},
"operator": {
"$dtId": "Amy",
"$etag": "W/\"7cdfdf34-acf1-424c-9143-b66b217217ee\"",
"$metadata": {
"$model": "dtmi:assetGen:MaintenancePersonnel;1"
}
}
},
{
"factory": {
"$dtId": "OsloFactory",
"$etag": "W/\"00246fff-cb8f-4813-bd5d-c5bc4baf89d3\"",
"$metadata": {
"$model": "dtmi:assetGen:Factory;1"
}
},
"location": {
"$dtId": "Norway",
"$etag": "W/\"02f1ec81-60ab-4620-832c-882d3e906e3b\"",
"$metadata": {
"$model": "dtmi:assetGen:Country;1"
}
},
"machine": {
"$dtId": "SaltMachine_C1",
"$etag": "W/\"3ae8d963-b3c6-4492-bd46-677237a8734d\"",
"$metadata": {
"$model": "dtmi:assetGen:SaltMachine;1",
"InFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.7052593Z"
},
"OutFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.7052593Z"
}
},
"InFlow": 332.79542269442237,
"OutFlow": 261.0988399811807
},
"operator": {
"$dtId": "Amy",
"$etag": "W/\"7cdfdf34-acf1-424c-9143-b66b217217ee\"",
"$metadata": {
"$model": "dtmi:assetGen:MaintenancePersonnel;1"
}
}
},
{
"factory": {
"$dtId": "OsloFactory",
"$etag": "W/\"00246fff-cb8f-4813-bd5d-c5bc4baf89d3\"",
"$metadata": {
"$model": "dtmi:assetGen:Factory;1"
}
},
"location": {
"$dtId": "Norway",
"$etag": "W/\"02f1ec81-60ab-4620-832c-882d3e906e3b\"",
"$metadata": {
"$model": "dtmi:assetGen:Country;1"
}
},
"machine": {
"$dtId": "PasteurizationMachine_A02",
"$etag": "W/\"fbe90625-ab2f-44b0-a752-e621a8151b16\"",
"$metadata": {
"$model": "dtmi:assetGen:PasteurizationMachine;1",
"InFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.5738043Z"
},
"OutFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.5738043Z"
},
"PercentFull": {
"lastUpdateTime": "2022-05-23T18:04:01.5738043Z"
},
"Temperature": {
"lastUpdateTime": "2022-05-23T18:04:01.5738043Z"
}
},
"InFlow": 230.3706403899462,
"OutFlow": 230.91679429466197,
"PercentFull": 0.08377026703751989,
"Temperature": 233.81506797732814
},
"operator": {
"$dtId": "John",
"$etag": "W/\"a2a9e9e7-2a1a-454b-b9f8-798a914d115c\"",
"$metadata": {
"$model": "dtmi:assetGen:MaintenancePersonnel;1"
}
}
},
{
"factory": {
"$dtId": "OsloFactory",
"$etag": "W/\"00246fff-cb8f-4813-bd5d-c5bc4baf89d3\"",
"$metadata": {
"$model": "dtmi:assetGen:Factory;1"
}
},
"location": {
"$dtId": "Norway",
"$etag": "W/\"02f1ec81-60ab-4620-832c-882d3e906e3b\"",
"$metadata": {
"$model": "dtmi:assetGen:Country;1"
}
},
"machine": {
"$dtId": "PasteurizationMachine_A03",
"$etag": "W/\"25f3e112-77c9-4c59-a14a-60f6f67b6fa3\"",
"$metadata": {
"$model": "dtmi:assetGen:PasteurizationMachine;1",
"InFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.6071772Z"
},
"OutFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.6071772Z"
},
"PercentFull": {
"lastUpdateTime": "2022-05-23T18:04:01.6071772Z"
},
"Temperature": {
"lastUpdateTime": "2022-05-23T18:04:01.6071772Z"
}
},
"InFlow": 231.93445886788967,
"OutFlow": 188.1200162797632,
"PercentFull": 0.3097249364634829,
"Temperature": 174.27167525276374
},
"operator": {
"$dtId": "John",
"$etag": "W/\"a2a9e9e7-2a1a-454b-b9f8-798a914d115c\"",
"$metadata": {
"$model": "dtmi:assetGen:MaintenancePersonnel;1"
}
}
},
{
"factory": {
"$dtId": "OsloFactory",
"$etag": "W/\"00246fff-cb8f-4813-bd5d-c5bc4baf89d3\"",
"$metadata": {
"$model": "dtmi:assetGen:Factory;1"
}
},
"location": {
"$dtId": "Norway",
"$etag": "W/\"02f1ec81-60ab-4620-832c-882d3e906e3b\"",
"$metadata": {
"$model": "dtmi:assetGen:Country;1"
}
},
"machine": {
"$dtId": "SaltMachine_C0",
"$etag": "W/\"145cb443-6cf2-4509-a4d1-06565c3b32ae\"",
"$metadata": {
"$model": "dtmi:assetGen:SaltMachine;1",
"InFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.6579164Z"
},
"OutFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.6579164Z"
}
},
"InFlow": 493.0541425679212,
"OutFlow": 273.5335459294844
},
"operator": {
"$dtId": "Xenia",
"$etag": "W/\"1a946968-8720-4852-883a-159cdda1d20c\"",
"$metadata": {
"$model": "dtmi:assetGen:MaintenancePersonnel;1"
}
}
},
{
"factory": {
"$dtId": "OsloFactory",
"$etag": "W/\"00246fff-cb8f-4813-bd5d-c5bc4baf89d3\"",
"$metadata": {
"$model": "dtmi:assetGen:Factory;1"
}
},
"location": {
"$dtId": "Norway",
"$etag": "W/\"02f1ec81-60ab-4620-832c-882d3e906e3b\"",
"$metadata": {
"$model": "dtmi:assetGen:Country;1"
}
},
"machine": {
"$dtId": "SaltMachine_C1",
"$etag": "W/\"3ae8d963-b3c6-4492-bd46-677237a8734d\"",
"$metadata": {
"$model": "dtmi:assetGen:SaltMachine;1",
"InFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.7052593Z"
},
"OutFlow": {
"lastUpdateTime": "2022-05-23T18:04:01.7052593Z"
}
},
"InFlow": 332.79542269442237,
"OutFlow": 261.0988399811807
},
"operator": {
"$dtId": "Xenia",
"$etag": "W/\"1a946968-8720-4852-883a-159cdda1d20c\"",
"$metadata": {
"$model": "dtmi:assetGen:MaintenancePersonnel;1"
}
}
}
]
}