graph-to-table 运算符

适用于：✅Azure 数据资源管理器Azure Monitor✅ Sentinel

运算符将 graph-to-table 节点或边缘从图形导出到表。

语法

节点

G|graph-to-tablenodes [ with_node_id=ColumnName ]

边缘

G|graph-to-tableedges [ with_source_id=ColumnName ] [ with_target_id=ColumnName ] [ asTableName ]

节点和边

G|graph-to-tablenodesasNodesTableName [ with_node_id=ColumnName ],edgesasEdgesTableName [ with_source_id=ColumnName ] [with_target_id=ColumnName ]

参数

退货

节点

运算符 graph-to-table 返回表格结果，其中每一行对应于源图中的节点。 返回的列是节点的属性。 提供时 with_node_id ，节点哈希列的类型 long 。

边缘

运算符 graph-to-table 返回表格结果，其中每一行对应于源图中的边缘。 返回的列是节点的属性。 提供或with_source_id提供时with_target_id，节点哈希列的类型long。

节点和边

运算符 graph-to-table 返回两个表格结果，与前面的说明匹配。

例子

以下示例对运算符如何将边缘从图形导出到表的方式 graph-to-table 进行反规范。 参数with_source_idwith_target_id导出每个边缘的源节点和目标节点的节点哈希。

let nodes = datatable(name:string, type:string, age:long) 
[ 
	"Alice", "Person", 23,  
	"Bob", "Person", 31,  
	"Eve", "Person", 17,  
	"Mallory", "Person", 29,  
	"Trent", "System", 99 
]; 
let edges = datatable(source:string, destination:string, edge_type:string) 
[ 
	"Alice", "Bob", "communicatesWith",  
	"Alice", "Trent", "trusts",  
	"Bob", "Trent", "hasPermission",  
	"Eve", "Alice", "attacks",  
	"Mallory", "Alice", "attacks",  
	"Mallory", "Bob", "attacks"  
]; 
edges 
| make-graph source --> destination with nodes on name
| graph-to-table edges with_source_id=SourceId with_target_id=TargetId

输出

获取节点

下面的示例演示如何 graph-to-table 运算符将节点从图形导出到表。 参数 with_node_id 导出节点哈希。

let nodes = datatable(name:string, type:string, age:long) 
[ 
	"Alice", "Person", 23,  
	"Bob", "Person", 31,  
	"Eve", "Person", 17,
	"Trent", "System", 99
]; 
let edges = datatable(source:string, destination:string, edge_type:string) 
[ 
	"Alice", "Bob", "communicatesWith",  
	"Alice", "Trent", "trusts",  
	"Bob", "Trent", "hasPermission",  
	"Eve", "Alice", "attacks",  
	"Mallory", "Alice", "attacks",  
	"Mallory", "Bob", "attacks"
]; 
edges 
| make-graph source --> destination with nodes on name
| graph-to-table nodes with_node_id=NodeId

输出

以下示例使用 graph-to-table 运算符将节点和边缘从图形导出到表。

let nodes = datatable(name:string, type:string, age:long) 
[ 
	"Alice", "Person", 23,  
	"Bob", "Person", 31,  
	"Eve", "Person", 17,
	"Trent", "System", 99
]; 
let edges = datatable(source:string, destination:string, edge_type:string) 
[ 
	"Alice", "Bob", "communicatesWith",  
	"Alice", "Trent", "trusts",  
	"Bob", "Trent", "hasPermission",  
	"Eve", "Alice", "attacks",  
	"Mallory", "Alice", "attacks",  
	"Mallory", "Bob", "attacks"
]; 
edges 
| make-graph source --> destination with nodes on name
| graph-to-table nodes as N with_node_id=NodeId, edges as E with_source_id=SourceId;
N; 
E

输出表 1

输出表 2

相关内容

• 图形运算符
• make-graph 运算符