Azure Streaming Analytics Query: Select latest data only
Hi All, I have very basic SQL experience and i'm a little stuck, so any help is appreciated. I'm working on a way to stream status of some jobs that are running on an HPC resource (sort of like trying to create a dashboard to look at real time flight…
Stream analytics: C# udf function not found in azure
Hi, I'm creating a stream analytics job with a function, which didn't work. Next I followed this tutorial: https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-edge-csharp-udf. It runs on my local pc, but when I test it in Azure…
Azure stream analytics: number in column name
Hi, I have a stream analytics job which outputs to azure table storage. Is it possible to do this when I have a column from which the name contains a numerical value? Regards, Filip Van Raemdonck
Does Stream Analytics query support simple binary operators (like + - etc)?
Azure Stream Analytics supports subset of Transaction-SQL and is explained by below document. Stream Analytics Query Language Reference stream-analytics-query-language-reference But I cannot find the simple binary operators (such as +, - etc)…
Access Nested JSON Array using stream analytics
I am fairly new to stream analytics and I have been trying to parse a nested JSON Array . I need to access the data under collections. The query I am using is as below. I also tried using getarrayelement before collections but that did not work either.…
How long do videos reside in Microsoft Stream?
Do videos automatically purge after a certain amount of time or do they stay in Microsoft Stream until they are manually deleted. Is there any retention policies available to setup. I am not seeing any place to do that. Thanks, Scott
Data stream between stream analytics services and WebApp service (.NET core 3.1)
Hello All, I and my team are trying to build an app for data visualization and analysis in WebApp the data source is from Stream Analytics Services, can we connect to Stream Analytics from .NET core web app, if there is any way please provide…
Access Control Exception on setting data lake storage gen1 as output
Hi, I am receiving JSON data as input of stream analytics job from IOT hub and trying to write it in Data Lake Storage Gen-1. The stream analytics job has read, write and execute permissions and I have read permission to Data Lake storage. According to…
What are the steps to configure a device in iot hub to work with stream analitycs job and can they be viewed in power bi service?
I configured the devices and reached the stage where they are displayed via stream in power bi service, but when turning off the device and turning it on again (obviously following the step of starting azure stream analytics) the data in the displays and…
Stream Analytics CI/CD :The required property 'storageAccounts' is missing from the request."
I am trying to do CI/CD for a Stream Analytics jobs. In this i have 2 inputs : Datalake Reference data (where I am using SQL DW) I have created the pipeline following the link https://github.com/SatyKrish/AzureStreamAnalytics-CICD …
Sample azure function for HBASE
Hello, I am trying to push data in HDInsights Hbase Cluster via Stream analytics jobs. Since there is no connectors available, i am looking for some sample azure function to complete my need as i am new to azure functions. Thanks & Regards, …