Share via

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

Ayyappa Koosam 0 Reputation points
2024-10-14T04:46:38.5933333+00:00

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

User's image

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.

User's image

User's image

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

User's image

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.

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,177 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,194 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
357 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 89,731 Reputation points Microsoft Employee
    2024-10-14T10:38:11.5433333+00:00

    @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.

    User's image

    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

    User's image

    OR

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

    User's image

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.