Copilot for EventHouse Queryset
Hi, RTI has introduced the preview feature of Copilot for the Eventhouse Queryset, but is there any way to automate the Copilot usage, via API endpoint or SDKs? The idea is to programmatically generate relevant and meaningful Kusto queries for business insights, from the tables and datasets present in the KQL DB in Eventhouse using Copilot. Thanks in advance!
Issue creating a KQL materialized view
Hi, I'm testing an eventstream that reads source events from an Azure Event Hubs and write them into a KQL table. I've created successfully a KQL materialized view (using summarize and arg_max clauses) with the backfill=true option, without specifying the async clause, while the eventstream was active. After two days, for debug purposes, I've tried to create a parallel materialized view with a different name using the same KQL code and I've obtained this error: But firts it isn't required the async keyword. So, I've tried to create an async materialized view using .create async materialized-view with (backfill=true) mymaterview on table mytable an OperationId is shown but it doesn't appear any materialized views. Now, I don't understand because first it isn't necessary to specify the async keyword and then I need to write it. Then, I don't understand because an async materialized view doesn't appear. I don't understand because I cannot create a parallel clone materialized view with a different name. I hope that a materialized view, created with or without the back fill option, keep updating with new source event data without executing any alter action on it. Any helps to me, please? Many thanks
KQL json mapping from Date Pipeline
Hi everyone. I’m running into an issue when ingesting data from MongoDB into my Kusto database using Azure Data Factory’s Copy Activity. Two of the fields in my source collection are Unix timestamps, but when they arrive in Kusto they end up stored as long instead of datetime. To fix this, I created a JSON ingestion mapping on my Kusto table that should convert those two timestamp columns into proper datetimes during ingestion. However, when I specify that mapping in the Copy Activity’s Sink settings, I get the following error: ErrorCode=KustoMappingReferenceHasWrongKind Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException Message=Mapping reference should be of kind 'Csv'. Mapping reference: 'UnixToDateTimeMapping'. Kind 'Json'. Source=Microsoft.DataTransfer.Runtime.KustoConnector I’ve tried passing the mapping name and adding various sink properties, but I can’t get ADF to apply my JSON mapping. Has anyone successfully configured a Copy Activity to use a Kusto JSON ingestion mapping? The code of my mapping as well .create-or-alter table info_connections_teste ingestion json mapping "UnixToDateTimeMapping" '[' ' { "column":"_id", "datatype":"string", "Properties":{"Path":"$._id"} },' ' { "column":"latency", "datatype":"real", "Properties":{"Path":"$.latency"} },' ' { "column":"packetloss_percentage","datatype":"int", "Properties":{"Path":"$.packetloss_percentage"} },' ' { "column":"download_occupancy","datatype":"real", "Properties":{"Path":"$.download_occupancy"} },' ' { "column":"upload_occupancy", "datatype":"real", "Properties":{"Path":"$.upload_occupancy"} },' ' { "column":"connection_id", "datatype":"string", "Properties":{"Path":"$.connection_id"} },' ' { "column":"createdAt", "datatype":"long", "Properties":{"Path":"$.createdAt"} },' ' { "column":"createdAtDate", "datatype":"datetime", "Properties":{"Path":"$.createdAt","Transform":"DateTimeFromUnixSeconds"} },' ' { "column":"updatedAt", "datatype":"long", "Properties":{"Path":"$.updatedAt"} },' ' { "column":"updatedAtDate", "datatype":"datetime", "Properties":{"Path":"$.updatedAt","Transform":"DateTimeFromUnixSeconds"} },' ' { "column":"__v", "datatype":"int", "Properties":{"Path":"$.__v"} }' ']'
