I have placed a .json file in the Data storage container which I have created, While I am trying the fetch the data thorough inputs from Stream analytics job, the data is not loading

Question

I have placed the .json file in the Storage account container(Date folder-->Time folder) as per the below screenshot.

And here I am trying to fetch the data which is present in the .json file in one of the input of the Stream analytics job as per the below screenshot. But here data is not populated as expected.

Have tested the test connection as well, Test connection is successful after testing as per the below screenshot.

While I am running the query, I am getting the message populated as "no data in devicerules"

Could you please assist me such a way that I could be able to fetch the fetch the data from .json file into the input of Stream analytic job.

Thanks much in advance.

Answer 1

@Ayyappa Koosam - Thanks for the question and using MS Q&A platform.

What is the time difference between the JSON file upload to the storage account and the querying the data from Azure Stream Analytics?

Note: The default time is set to 3 minutes if the JSON file upload to the storage account is greater than 3 minutes it's execpted that it will throw the below error message. There is no data from input 'asasample'. Please make sure the input source has data and then try again.

As soon as you upload the file, you can also see the file contents in the form as a table or in it's raw format. If you select Reset, the sample data will return to the incoming input data explained in the previous section. You can upload any other file to test the query at any time.

OR

Make sure to modify the select time range to match the time you uploaded the JSON file upload to the storage account. In case, if you had uploaded 30minutes back

OR

If your data shown isn't current, select Refresh to see the latest events.

For more details, refer to Stream data from Blob storage or Data Lake Storage Gen2 and Test an Azure Stream Analytics job in the portal.

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.