Unable to retrieve data from reference dataset in Azure Stream Analytics

James 0 Reputation points
2023-04-28T20:16:53.94+00:00

I am trying to run my first Azure Streaming Analytics query:

User's image

But when I test the query I get the message "There is no data from input 'referencedata'. Please make sure the input source has data and then try again."

The reference dataset is in an ADLS Gen 2 account.

My reference dataset details:

User's image

The storage location:

User's image

The data:

User's image

Please advise.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,335 questions
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.
2,670 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
330 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sander van de Velde 28,236 Reputation points MVP
    2023-05-01T23:01:18.04+00:00

    Hello James,

    I see you are using a Blob storage with the year/month/day path format.

    In the past, I also worked with reference data and I used the Time field too.

    Can you add an extra level to the path for the hour? The sub path '00' will do already.

    You need to change the path pattern too.

    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

    0 comments