Im trying to send Data from my IoTHub Input to my Sql Database output, but tables stay empty?
Hello everyone, Im currently working on a university-project and I'm connecting my Raspberry Pi Pico with Azure. The Pico is sending temperature data, which is recieved in the IoTHub Input im my analytics stream, but when I'm trying to send the data to…
Data sync issue in Stream Analytics job to Azure SQL database
I am using the Raspberry Pi Azure IoT Online Simulator to push the data (in the interval of every 500 milli seconds) to Azure IoT hub (Basic Tier) using this link https://azure-samples.github.io/raspberry-pi-web-simulator/ I have configured Stream…
Stream Analytics: Why does state of reference data retrieval not leave "In progress"
Hi, I'm using a CSV file from Azure Blob Storage as a reference input source in a Stream Analytics resource. Right now this file is updated every twenty minutes, but this will change to longer periods as our testing progresses. Within the activity logs…
How to recover Stream Analytics job to normal Running status from Degraded state?
Hello, My stream analytics job had been working fine with IoT Hub stream input and SQL DB as reference input, output is written to storage account. Yesterday there was an unplanned Azure service issue with IoT Hub in my region and it lasted for around 6…
Trying to ingest filter Kafka header and filter into my azure stream analytics job
Hello I am trying to ingest kafka header in azure stream analytics job - i successfully connected to an input kafka topic, containing standard and custom headers. When testing the query, i only get data field. I tried GetMetadataPropertyValue function,…
Unable to update Cosmos DB documents with Hierarchical partition keys using Azure Stream Analytics job
I have document in Cosmos DB with Hierarchical partition keys. I want to patch certain property value. But while running the job I am getting this error👇 The streaming job failed: Stream Analytics job has validation errors: Error connecting to…
Records Column (json) to convert one column to multiple rows in Azure Streaming Language
I have a ID column and Records column with the values in different rows between square brackets in it. Azure Streaming analytics language, I would want to split the values between square brackets pivot into multiple rows .
User Header filter from Kafka enabled Azure eventhub using Azure Stream Analytics query
I have a Kafka enabled azure eventhub where am publishing the data from my client application. To publish i use the confluent kafka dot net package. Each message has a User header (message headers). The Eventhub has 10 partitions. Multiple tenants (5)…
How to achieve streaming ingestion for ASA input to ADX?
Hi, I've set up an ADX Dev cluster which has been configured for streaming. I created a Database and Table which both had their streamingingestion policies enabled. I used this MS Link to create an ADX output from an Azure Stream Analytics job I…
Input file to Azure Stream analytics in Json format error while previewing
Thanks for your time, I have a job in azure stream analytics with an input json format file which is accessed through Azure data lake. the format of json is of format [{"tag":…
Stream Analytics Job Output Stuck
I have a stream analytics job with an MQTT JSON input and a postgreSQL output. I noticed that if a certain JSON parameter that is part of the message no output rows are generated. I couldn't find any related info in the logs. Restarting the stream…
Issue with max block count in Azure Data Lake Gen2
Starting from 03/02/23 I have noticed that my Stream Analytics Job has been creating more files per day than before. Looking through the files' properties I discovered that every file maxes out at 10000 blocks and then the SA Job creates another one,…
How to hide a column in Azure Stream Analytics Data Preview
Is there anyways to hide the column in Azure Stream Analytics Data Preview? In my case, I want to hide column "properties" in data preview. Thanks!
Why are booleans in Stream Analytics sample outputs getting converted into 0's and 1's?
When using the data sampler available from Event Hubs -> namespace -> Process Data, and running the default sample query, we've recently noticed that values that would previously show as booleans are now converting into 0 or 1 in the…
Difference between schema.history and database.history in mysql connector
I set up kafka, mysql and debezium in my computer successfully. However, i have still not understood about the difference between database.history.kafka.topic and schema.history.internal.kafka.topic. Below is my connector: Please help me explaining the…
How to use AnomalyDetection_ChangePoint Anomaly detection?
Hi , I look to find the anomaly detection using AnomalyDetection_ChangePoint two parameters using Tumbling window grouping(since its a non stable value input), but I have doubt regarding the set point, is it possible to give a set point or threshold…
How to read inputs from beginning?
Hi there, currently I'm testing Stream Analytics for a streaming application and facing the issue that my job only reads data that is incoming after it has been started. Data that has been present before won't be processed. I tested this behaviour with…
Stream analytics LAST method Partition by
When using Stream Analytics LAST built in method do you set a property which is "PARTITION BY", does this mean that you change the overall partitioning you set from the input stage or is this somehow locally. For clarification, you can set…
Stream Analytics query giving Null while filtering Modbus module payload from azure iotedge
Hi Team, I'm getting invalid syntax error while trying to extract the "Values" Array. I have tried multiple query patterns to list all displayNames and its corresponding Value in columns, please find sample input json below [ { …
I am passing a Stream to the service but never return the text
speech-sdk-log.txt I am trying to convert live stream to text , this works fine with microphone , but when i send the Stram it was not recognized I already try same stremresult file and works fine from file but not for live stream …