Stream Analytics - Reference Data

Question

Stream Analytics - Reference Data

Prabhu Rsp 1

Hi,

I have to set a pipe line to get data's into "stream analytics job service" from sql database directedly( should not use other layers/components Ex: Data factory, Event hubs etc between sql db and stream analytics job ) . But no stream input in my use case. Tried by using this link with by adding reference data input option

"https://learn.microsoft.com/en-us/azure/stream-analytics/sql-reference-data "

But received "Query must refer to at least one data stream input" this error. Query expects always at least one stream input.

Please let me know to to achieve this with out using code only through pipelines.

Thank You.

CarrinWu-MSFT 6,891 Reputation points

2021-08-13T01:47:38.817+00:00

Hi @Prabhu Rsp ,

Welcome to Microsoft Q&A!

Sorry about that I am not familiar with Azure Stream Analytics, I just working with SSAS. But base on my research, you could refer to this thread.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
CarrinWu-MSFT 6,891 Reputation points

2021-08-16T06:13:51.387+00:00

Hi @Prabhu Rsp , we have not get a reply from you. Did below answer could help you? If yes, please do "Accept Answer". If not, please feel free to let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

1 answer

Your answer

CarrinWu-MSFT 6,891 Reputation points

2021-08-13T01:47:38.817+00:00

Hi @Prabhu Rsp ,

Welcome to Microsoft Q&A!

Sorry about that I am not familiar with Azure Stream Analytics, I just working with SSAS. But base on my research, you could refer to this thread.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
CarrinWu-MSFT 6,891 Reputation points

2021-08-16T06:13:51.387+00:00

Hi @Prabhu Rsp , we have not get a reply from you. Did below answer could help you? If yes, please do "Accept Answer". If not, please feel free to let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

Answer 1

HimanshuSinha-msft 19,486 Microsoft Employee Moderator

Hello @Prabhu Rsp ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time ASA supports only 4 different streaming inputs .

Azure Event Hubs
Azure IoT Hub
Azure Blob storage
Azure Data Lake Storage Gen2

and you will have to use one of these and then only you can use reference data source ( like SQL ) .

If you do not want use any other layer , i do not think you can use ASA .

Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-08-17T16:10:58.933+00:00

Hello @Prabhu Rsp ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-08-18T16:24:29.87+00:00

Hello @Prabhu Rsp ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Sander van de Velde | MVP 36,761 Reputation points MVP Volunteer Moderator

2021-08-18T18:34:49.99+00:00

Hello @Prabhu Rsp ,

The right answer is given if you combine the answers of both @HimanshuSinha-msft and @CarrinWu-MSFT .

Azure Stream Analytics is a service which ingests messages from one or more inputs, enriches or filters or joins with reference data and sends the data to one or more outputs.

Azure Stream Analytics is not able to listen to 'static' Sql Server data. You need to 'trigger' the Stream Analytics query in some ways using one of the input streams. Only then, the Sql Server table data can referenced.

Share via

Stream Analytics - Reference Data

1 answer

Your answer