User Profile
UriBarash
MicrosoftJoined 8 years ago
User Widgets
Recent Discussions
Re: Is there any way to update data in ADX?
ashgoel1895 - Rows do not have a unique ID but you can add one (before you ingest or using an update policy with new_guid() ) https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/updatepolicy https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/newguidfunction7.7KViews0likes0CommentsRe: Query help: Render array entries in barchart - timegenerated
HelloDalesss Check out this: let data=datatable(timestamp:datetime, elements:dynamic)[ '2020-02-02', dynamic(['foo', 'bar', 'foo2', 'bar2']), '2020-02-03', dynamic(['foo', 'bar', 'foo2', 'bar2']), '2020-02-04', dynamic(['boo', 'far', 'boo2', 'far2', 'boo3']), '2020-02-05', dynamic(['boo', 'far', 'boo2', 'boo3'])]; data | mv-expand elements | summarize count() by timestamp, tostring(elements) | render columnchart with(kind=stacked)778Views0likes0CommentsRe: Application Insights data from Data Lake into Data Explorer
Hello vukovicd, Many folks are routing data from Azure Monitor Application Insights to Azure Data Explorer automatically. Data from Application Insights ends up as jsonl - A set of json objects each one in its own line in the file. Typically they use the EventGrid method to listen on the data lake container and automatically ingest data as it lands. https://docs.microsoft.com/en-us/azure/data-explorer/ingest-data-event-grid In order to set up the tables, column mappings etc, 1-click ingestion helps you do it based on your data sample: https://docs.microsoft.com/en-us/azure/data-explorer/ingest-data-one-click Please let us know how it works for you. Uri2.1KViews0likes0CommentsRe: SQL Server to Kusto
Hello Lawrence, here are a few options for you to consider: 1. Use Azure Data Factory(ADF) - https://techcommunity.microsoft.com/t5/azure-data-explorer/azure-data-factory-adf-now-supports-azure-data-explorer-kusto/ba-p/332446 2. Automate a query from Azure Data Explorer to the Azure SQL DB using the sql request plugin and use .set-or-append to add the data to you table. https://docs.microsoft.com/en-us/azure/kusto/query/sqlrequestplugin (You can automate using ADF control command functionality or via Flow) 3. Use the Azure SQL DB DB export to output data to CSV to blob and then ingest it into Azure Data Explorer. Cheers Uri4.3KViews0likes0Comments
