你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
azure_digital_twins_query_request plugin
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
The azure_digital_twins_query_request plugin runs an Azure Digital Twins query as part of a Kusto Query Language (KQL) query. The plugin is invoked with the evaluate operator.
Using the plugin, you can query across data in both Azure Digital Twins and any data source accessible through KQL. For example, you can perform time series analytics.
For more information about the plugin, see Azure Digital Twins query plugin.
Syntax
evaluate azure_digital_twins_query_request ( AdtInstanceEndpoint , AdtQuery )
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| AdtInstanceEndpoint | string |
✔️ | The Azure Digital Twins instance endpoint to be queried. |
| AdtQuery | string |
✔️ | The query to run against the Azure Digital Twins endpoint. This query is written in a custom SQL-like query language for Azure Digital Twins, called the Azure Digital Twins query language. For more information, see Query language for Azure Digital Twins. |
Authentication and authorization
The azure_digital_twins_query_request plugin uses the Microsoft Entra account of the user running the query to authenticate. To run a query, a user must at least be granted the Azure Digital Twins Data Reader role. Information on how to assign this role can be found in Security for Azure Digital Twins solutions.
Examples
The following examples show how you can run various Azure Digital Twins queries, including queries that use additional Kusto expressions.
Retrieval of all twins within an Azure Digital Twins instance
The following example returns all digital twins within an Azure Digital Twins instance.
evaluate azure_digital_twins_query_request(
'https://contoso.api.wcus.digitaltwins.azure.net',
'SELECT T AS Twins FROM DIGITALTWINS T')
Projection of twin properties as columns along with additional Kusto expressions
The following example returns the result from the plugin as separate columns, and then performs additional operations using Kusto expressions.
evaluate azure_digital_twins_query_request(
'https://contoso.api.wcus.digitaltwins.azure.net',
'SELECT T.Temperature, T.Humidity FROM DIGITALTWINS T WHERE IS_PRIMITIVE(T.Temperature) AND IS_PRIMITIVE(T.Humidity)')
| where Temperature > 20
| project TemperatureInC = Temperature, Humidity
Output
| TemperatureInC | Humidity |
|---|---|
| 21 | 48 |
| 49 | 34 |
| 80 | 32 |
Perform time series analytics
You can use the data history integration feature of Azure Digital Twins to historize digital twin property updates. To learn how to view the historized twin updates, see View the historized twin updates