Azure Stream Analytics reference input cannot read from Storage blob

Question

We are trying to create a Storage reference input for Azure Stream Analytics job and all the configuration and the test goes well, however when we try to use it in a Query, we get the following messages in the portal UI: "While sampling data, no data was received from '1' partitions." and "No data was found for preview from 'refinput'. Make sure the input has recently received data and the correct format of those events has been selected." It is a CSV file that we have uploaded in the storage account and it is static data that doesn't change. The blob is a valid CSV and can be downloaded and opened in Excel without problems.

Any ideas on what the issue can be?

Answer 1

Firstly, I have to say blob storage reference inputs cannot be previewed which is stated in the ASA portal UI.

As we know, reference input should be used in JOIN with Stream Input,can't be used alone. So, I suppose the error you met occurs when you test stream input join reference input. I reproduce same issue as yours, please see:

Per my knowledge, Preview Data is for real-time input stream, it simulates the real execution of ASA job. So you have to make sure that the input has recently received any correct format (which is indicated by error message exactly). Surely, you could set time range to scale the appropriate scope as you want.

As for upload sample data, that's totally static sample which will not be affected by any time settings. Just static data for test!