Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
158 questions
1 answer
One of the answers was accepted by the question author.
Missing record in table storage (from stream analytics)
Hi everybody, I have a problem of missing records in a table storage account. I use a stream analytics job to send data from an IOTHub to a table storage. The stream analytics job seems working correctly (output event count seems correct). I expect…
asked 2021-02-10T09:25:32.913+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 75%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
BERNARD Thomas
166
Reputation points
accepted 2021-02-10T15:54:10.157+00:00
BERNARD Thomas
166
Reputation points
2 answers
One of the answers was accepted by the question author.
error: not found: value EventHubsConf
Hi Everyone, I was trying to do some real-time stream analytics using databricks and azure event hub but I keep running into this error even when I have configured everything well. Here is the code snippet : import java.util._ import…
asked 2021-02-08T10:56:02.347+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 61%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
snehil singh
21
Reputation points
answered 2021-02-09T06:28:57.547+00:00
snehil singh
21
Reputation points
1 answer
Unable to fetch data from stream analytics job enabled with managed identity
Unable to fetch data from stream analytics job enabled with managed identity getting input from event hub (in other subscription). In "Subscription A", i have a Stream Analytics Job enabled with managed identity. This job is getting its input…
asked 2021-02-01T13:29:40.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 44%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Abhijit Jadhav
1
Reputation point
commented 2021-02-05T07:15:33.287+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
2 answers
Stream Analytic Partition input
I have set the partition ID for the into with a name "deviceID" And in the query , I find that the build in column partitionID is different from my desired partition column (deviceID). why is that ? IS is normal ? And my table in DB…
asked 2021-01-24T10:24:30.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
Reputation points
commented 2021-02-03T18:22:53.457+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
1 answer
Stream analytics Output
suppose I have an output to sql server table there is an option "inherit partition scheme of previous query step or input" So the writing to SQL database table is in parallel ? The target SQL database table also…
asked 2021-01-21T13:39:44.383+00:00
sakuraime
2,321
Reputation points
commented 2021-02-02T17:22:05.763+00:00
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
0 answers
Disappearing files from Blob Storage
Hi everyone. I have recently set up an Azure IoT Hub that is accepting telemetry data from an MQTT source. I have also set up an Azure Stream Analytics Job which simply takes the input and writes it to a Gen 2 Storage account (Data Lake, Hierarchy…
asked 2021-01-21T11:49:11.787+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 40%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Scott
6
Reputation points
commented 2021-02-02T17:21:26.987+00:00
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
2 answers
Inputs to Streaming Analytics Job
I have an event hub (in other subscription) which is to be used as input to the streaming analytics job. This event hub is configured to allow connections from "Select network only". In such a case is there a way to get data from this event hub…
asked 2020-08-20T08:56:04.717+00:00
Abhijit Jadhav
1
Reputation point
answered 2021-02-01T14:10:13.397+00:00
Abhijit Jadhav
1
Reputation point
1 answer
can i query two time series instances in one request?
{ "aggregateSeries": { "timeSeriesId": [ "PickTime", "EMP010" ], // further logic I am trying to query two time series instances in the single request body through…
asked 2021-01-05T13:20:49.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 95%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Purohit, Aahana
1
Reputation point
commented 2021-01-14T17:56:27.593+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,031
Reputation points
1 answer
Stream Analytics output system property override not working
Hello, I have a streams analytics query that is outputting events to a Service Bus Queue. I would like to manually set the "EventEnqueuedUtcTime" system property on the output. In my stream analytics set up, I set the "System…
asked 2020-12-17T18:55:13.927+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 5%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CareyBoldenow
96
Reputation points
commented 2021-01-11T05:58:57.04+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Rest API Data stream to event hub
Hi Guys, We are using below rest api get method of accuweather to fetch location info curl --location --request GET 'http://dataservice.accuweather.com/locations/v1/adminareas/countryCode?apikey=VU86G' PostMan output: …
asked 2020-12-30T16:21:21.083+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 48%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dondapati, Navin
281
Reputation points
accepted 2021-01-05T16:07:01.147+00:00
Dondapati, Navin
281
Reputation points
0 answers
ASA degraded flag and no output when using JSON_VALUE in query
I get a degraded flag as soon as I use a JSON_VALUE command in my ASA query. The query works fine when I test it and there are no other errors reported when I run the job. Just no output and degraded message.
asked 2020-12-22T20:58:11.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 11%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NB
1
Reputation point
commented 2020-12-28T06:19:35.11+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
Data Lake Central alerting
Hi Guys We are planning to build centralize alert system on Azure Source systems Splunk Solarwinds SAP Alert Management Oracle Alert log Talend Job Logs Cisco Information Service Azure Logs what would the easy way to gather all the…
asked 2020-12-17T21:42:13.313+00:00
Dondapati, Navin
281
Reputation points
answered 2020-12-18T11:56:52.213+00:00
Pramod Valavala
20,591
Reputation points Microsoft Employee
0 answers
How to troubleshoot UDF error in Stream Analytics?
My Stream Analytics jobs has multiple errors like this: { "Environment": "Prod", "Region": "North Europe", "time": "2020-10-03T00:04:22.9834272Z", "resourceId":…
asked 2020-11-11T14:01:23.453+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 56.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Mikael Falkvidd
1
Reputation point
commented 2020-12-15T18:01:33.457+00:00
Mikael Falkvidd
1
Reputation point
1 answer
Azure Stream Analytics Job Reference Input Join Error
Hi Team My Inputs for Stream Analytics Job: Input 1: Stream Input from IoT Hub Input 2: Reference Data from Azure Blob Storage I am trying to use following query to join stream input (deviceinput) and reference input…
asked 2020-11-18T14:11:41.307+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 48%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kamlesh Khollam
21
Reputation points
answered 2020-12-10T06:20:46.003+00:00
Kamlesh Khollam
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Stream Analytics Job Reference Input SQL DB error
Hi Team, I have added SQL DB as Reference Input for Stream Analytic job. After adding on Query window its giving error: Cannot read property 'resourceId' of null Following is the screenshot for the same: Please refer the Red highlighted info:…
asked 2020-11-24T12:08:39.433+00:00
Kamlesh Khollam
21
Reputation points
accepted 2020-12-10T06:15:37.46+00:00
Kamlesh Khollam
21
Reputation points
0 answers
Azure Stream Analytics Reference Input: SQL DB Snapshot Error
Hi Team, I am using SQL DB as Reference Input in Stream Analytics Job. When I Start the stream analytics job, Reference Input(SQL DB) shows following error: I did check my Storage Account Details and it looks correct. But not sure why…
asked 2020-11-25T18:56:23.713+00:00
Kamlesh Khollam
21
Reputation points
commented 2020-12-08T10:46:38.66+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
Azure Stream Analytics
I was just wondering if we should just let the Stream Analytics running continuously so the data from the storage gets fed into out SQL database continuously (so every time new events get added onto the storage then the database gets automatically…
asked 2020-11-06T16:03:17.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2020-11-17T09:36:45.127+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
Failed to Locate a Column at Position x in the Output Event
Hi all I'm running an export job out of IOTCentral for measurements data and that is going into an Event Hub. I'm then using Stream Analytics to move the data into an Azure SQL table. I've switched on the error tracking in the Stream Analytics log and…
asked 2020-11-02T13:11:27.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 62%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
John Clifford
21
Reputation points
commented 2020-11-16T22:06:10.853+00:00
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
1 answer
ASA UDA deaccumulateState not firing?
Hi, According to the documentation ASA javascript UDAs can be used for deaccumulation. It states -The deaccumulateState() method recalculates state based on the previous state and the state of a hop. This method is called when a set of events leave a…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 98%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
Azure Stream Analytics Job cannot detect either input table or output table
I'm new to the Azure Stream Job, and I want to use the reference data from Azure SQL DB to load into Power BI to have streaming data. I've set up the storage account when setting up the SQL input table. I test the output table (Power BI) which is also…
asked 2020-10-13T22:40:13.047+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 24%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bptsai
1
Reputation point
commented 2020-11-09T07:31:49.687+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee