Azure powered real time analytics architecture is now more powerful with native integration of Azure Data Explorer as output for Azure Stream Analytics. With this new integration Azure Stream Analytics job can natively ingest the data into Azure Data Explorer table.
This pattern allows low latency on the alerts based on Azure Stream Analytics input stream and with logs being ingested into Azure Data Explorer, you can run deeper investigations, find out patterns, review anomalies with your data and more.
Create Azure Data Explorer output connection to Azure Stream Analytics job
Under the Azure Stream Analytics job, select Outputs and then select Azure Data Explorer
Enter the required information into the output connection
Save your connection and start your Azure Stream Analytics job. Output of your SQL query specified in your Azure Stream Analytics job will now be ingested into your Azure Data Explorer table.
Note: For the ingestion to successfully work, you need to make sure that -
Number of columns in Azure Stream Analytics job query should match with Azure Data Explorer table and should be in the same order.
Name of the columns & data type should match between Azure Stream Analytics SQL query and Azure Data Explorer table.
When to use Azure Data Explorer or/and Azure Stream Analytics