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

Question

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?

Thank you!!

Answer 1

Hello @bptsai ,

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:

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.

Answer 2

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.