azure - 如何在 Azure 数据资源管理器中创建物化视图时添加多个维度表

Question

我正在尝试使用二维表创建物化视图，但使用以下语法出现错误，

.create async materialized-view with (backfill=true, dimensionTables = 'SalesUserTable','ProductTable') SalesSummary on table PurchaseTable
{
PurchaseTable | join kind = inner SalesUserTable on $left.SalesUserId == $right.SalesUserID
| join kind = inner ProductTable on $left.ProductID == $right.ProductID
| extend TotalPrice = (Quantity*Price)
| summarize
TotalQuantity = sum(Quantity),
TotalPrice = sum(TotalPrice)
by SalesUserId, ProductID, SalesUserName=Name, ProductName=Name1
}

请帮助我使用正确的语法来添加多维表

标签： azureazure-data-explorermaterialized-views

Answer 1

将表名放在一组引号中：

.create async materialized-view with (backfill=true, dimensionTables = 'SalesUserTable, ProductTable') SalesSummary on table PurchaseTable