how to add more than one dimension table while creating a materialized view

Bharath Kumar B 21 Reputation points
2021-10-07T15:04:59.127+00:00

HI Team,

I am trying to create a materialized view with 2 dimension tables, but getting error with the below syntax,

.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
}

Please help me with the right syntax to add multiple dimension table

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions
{count} votes