Stream Analytics Job - no output in SQL

Sutheswaran, Suwhathi 70 Reputation points
2023-11-01T18:52:40.7266667+00:00

Hello Team,

i am facing with Stream Analytics Job with Output for SQL.

I wrote a query and the output showing me the results which I expects.

But somehow the results is not showing in my SQL table.

I am running out of ideas. Not sure why it’s not working

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
331 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,809 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee
    2023-11-08T04:30:30.1333333+00:00

    @Sutheswaran, Suwhathi - I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

    Ask: Stream Analytics Job - no output in SQL

    Solution: I just use the Error Policy in ASA and get the results.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.


1 additional answer

Sort by: Most helpful
  1. Sutheswaran, Suwhathi 70 Reputation points
    2023-11-06T14:47:00.13+00:00

    Hi ,

    i could solve the problem .

    I just use the Error Policy in ASA and get the results