question

bptsai-1905 avatar image
bptsai-1905 asked ·

Azure Stream Analytics Job cannot detect either input table or output table

I'm new to the Azure Stream Job, and I want to use the reference data from Azure SQL DB to load into Power BI to have streaming data. I've set up the storage account when setting up the SQL input table. I test the output table (Power BI) which is also fine, no error.

I tested both input table and output table connection, both are successfully connected, and I can see the input data from Input preview.

But when I tried to compose the query to test it out, the query cannot detect either input table or the output table. The output table icon also grey out.

Error message: Query must refer to as least one data stream input.

Could you help me?
32154-image.png



Thank you!!

azure-stream-analytics
image.png (173.1 KiB)
5 comments
10 |1000 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 @WendyTsai-1905,

Welcome to Microsoft Q&A platform.

Thanks for bringing this to our attention. I’m working with the product team and get back to you when I have more information.

0 Votes 0 · ·

Hello @WendyTsai-1905,

We are still waiting for the response from the product team. I will let you know once I heard back from product team.

Stay Tuned!

0 Votes 0 · ·
bptsai-1905 avatar image bptsai-1905 PRADEEPCHEEKATLA-MSFT ·

Hi @PRADEEPCHEEKATLA-MSFT , thanks for the update!

0 Votes 0 · ·
Show more comments
PRADEEPCHEEKATLA-MSFT avatar image
PRADEEPCHEEKATLA-MSFT answered ·

Hello @bptsai-1905,

The test query portal will not allow you to test the query if there are syntax errors. You will need to correct the syntax (as seen by yellow squiggles) before testing.

Here is a sample test query without any syntax error messages:

33517-image.png

33409-image.png


33486-asa-stream-testquery.gif

Hope this helps. Do let us know if you any further queries.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.



image.png (119.5 KiB)
image.png (1.2 KiB)
1 comment Share
10 |1000 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,

Thank you for looking into this, I appreciate it!

I updated the syntax to look like yours, but there's still yellow line below showing syntax errors.. could you help me ?
33665-image.png



Thanks!

0 Votes 0 · ·
image.png (52.6 KiB)
JS-Azure avatar image
JS-Azure answered ·

Hi,
Stream Analytics does require to have at least one source coming from one of these 3 streaming sources: Event Hubs, IoT Hub, or Blob/ADLS. We don't support SQL as a streaming source at this time, that's why the query is not valid. For the query to be valid, you need to JOIN streams and reference data (e.g. to augment the stream), then you need to have data flowing in the streaming source to see output.

If you scenario is to get data from SQL to Power BI directly, you can actually directly connect Power BI to your SQL source.

34065-image.png



image.png (130.8 KiB)
image.png (130.8 KiB)
Share
10 |1000 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.