Add Query Parameters to the SA job configuration settings.
Create query parameters (stored in configuration settings) for the SA job so that common values can be controlled without modifying the query itself.
Roger Johnson
shared this idea
AdminAzure Stream Analytics Team on UserVoice
(Product Manager, Microsoft Azure)
responded
While we are looking into ways to make this pattern more explicit, this is actually supported today using reference data. Store your parameter bindings in a blob as JSON and join against that reference data in your query to retrieve parameter values. You can change parameters over time by writing new blobs and without halting the ASA job.
2 comments
-
Roger Johnson
commented
One use case involves being able to control (from a single source) the window parameters for a group of queries. The thinking here is to manage all related queries time windows via a common configuration setting.
Also, this use case could not be satisfied with joined reference data.
Example:
Job Query 1:SELECT
System.TimeStamp AS PointTime,
COUNT(SessionId) AS Count
FROM [inputhub] TIMESTAMP BY EventTime
GROUP BY
SessionId, TUMBLINGWINDOW(minute, CONFIGVALUE(‘QueryWindowTime’))Job Query 2:
SELECT
System.TimeStamp AS PointTime,
AVG(WaitTime) AS Count
FROM [inputhub]
GROUP BY
SessionId, TUMBLINGWINDOW(minute, CONFIGVALUE(‘QueryWindowTime’))Other use cases like filtering on an input query field could be done via reference data, but again I would prefer that option to be supported by configuration settings as well.
-
Sudhesh Suresh
commented
Can't this be accomplished using reference data?