question

PrabhuRsp-1535 avatar image
0 Votes"
PrabhuRsp-1535 asked SandervandeVelde42 commented

Stream Analytics - Reference Data

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://docs.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.

azure-sql-databasesql-server-analysis-servicessql-server-migrationazure-stream-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PrabhuRsp-1535,

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.

0 Votes 0 ·

Hi @PrabhuRsp-1535, 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!

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered SandervandeVelde42 commented

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

  1. Azure Event Hubs

  2. Azure IoT Hub

  3. Azure Blob storage

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

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @PrabhuRsp-1535 ,
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

0 Votes 0 ·

Hello @PrabhuRsp-1535 ,
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

0 Votes 0 ·

Hello @PrabhuRsp-1535,

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.

0 Votes 0 ·