How can I output data to output sources with the same alias?

kunming jian 60 Reputation points
2023-09-20T09:34:51.8+00:00

My stream analysis job generates different types of data when processing input source data. How can I sequentially output these data to output sources with the same alias? Or what other methods are there？If I cannot output to an output source with the same alias, I may need to create hundreds of outputs with different aliases, which is a very foolish task.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
342 questions
0 comments
Accepted answer
  1. Sander van de Velde | MVP 30,866 Reputation points MVP
    2023-09-20T10:55:58.03+00:00

    Hello @kunming jian ,

    Each ASA output can be written by only one query. An output cannot be reused by multiple queries.

    You can however use UNION:

    Combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union.

    This way, if the format of the message of each query is the same (number of columns, types of columns, column order), these can be combined.

    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest