Creating a materialized view in KQL language with only some table columns

[pmscorca]

Hi,

I need to create a materialized view that must expose only some table columns with a similar KQL code, that goes in error:

.create materialized-view mv_test on table mytable
{
    summarize arg_max(version, *) by id
    | project id, version, column1, column2
}

Moreover, is it possible to return one of this columns converted in a datetime?

Thanks

[pmscorca · Accepted solution]

Hi,

I've solved with a such statement:

.create materialized-view mv_test on table mytable
{ mytable
     | extend duedatetime = todatetime(duedatetime)
     | project id, version, duedatetime, column1, column2
     | summarize arg_max(version, *) by id
}

Thanks

[v-junyant-msft]

Hi @pmscorca ,

Glad to see you solved your problem yourself, please remember to mark your reply as SOLUTION so that more users can find solutions and learn faster. Thanks!

Best Regards,
Dino Tao