AdminAzure Stream Analytics Team on UserVoice (Product Manager, Microsoft Azure)

My feedback

  1. 23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Can you achieve this by using a Javascript UDF? We will soon be releasing C# UDFs as well. Would these options meet your requirements?

  2. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Stream Analytics » Query Language  ·  Flag idea as inappropriate…  ·  Admin →

    Hi, thanks for reporting this. Sorry for the late response.
    Other types, like DATETIME do work, but only if there is an explicit CAST or CREATE TABLE.
    i.e. you would have to do “min(cast (d as datetime))” vs. just “min(d)”
    We'll update the doc with this information.

  3. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Stream Analytics » Inputs and Outputs  ·  Flag idea as inappropriate…  ·  Admin →
  4. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Stream Analytics » Inputs and Outputs  ·  Flag idea as inappropriate…  ·  Admin →

    Hi, this is a supported scenario. Do you have any issue when running your job? Can you share more info here?

  5. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Stream Analytics » Inputs and Outputs  ·  Flag idea as inappropriate…  ·  Admin →
  6. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Stream Analytics » Advanced Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  7. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Stream Analytics » Inputs and Outputs  ·  Flag idea as inappropriate…  ·  Admin →
  8. 22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  2 comments  ·  Stream Analytics » Inputs and Outputs  ·  Flag idea as inappropriate…  ·  Admin →
  9. 23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Stream Analytics » Query Language  ·  Flag idea as inappropriate…  ·  Admin →

    REPLACE is now available in the product: https://docs.microsoft.com/en-us/stream-analytics-query/replace-azure-stream-analytics
    (Editing the title to reflect this change and track other functions)

    Thank you for the feedback Krishna. We are constantly extending set of built-in functions and will consider these functions in one of the next iterations. This is the list of currently supported string functions: https://msdn.microsoft.com/en-us/library/azure/dn931798.aspx

  10. 28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  Stream Analytics » Query Language  ·  Flag idea as inappropriate…  ·  Admin →

    The ROUND method had been added to the product. The documentation is here: https://docs.microsoft.com/en-us/stream-analytics-query/round-azure-stream-analytics

    I'll rename this suggestion to track the "split" function that is not yet available.

  11. 114 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedbacks. In order to reduce cost, it is possible to use 1 SU for small jobs (this is about $80 per month).
    1 SU jobs are able to have different sources, sinks and query steps. So it's actually possible to pack various queries inside 1 job.

  12. 32 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    By user timestamped reference data, the reference data will be refreshed when the job is running.

  13. 28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Stream Analytics » Security  ·  Flag idea as inappropriate…  ·  Admin →
  14. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    A workaround for this would be to create 2 jobs:
    - A first job for the critical output (keeping the error policy to "retry")
    - A second job for non-critical output (changing the policy to "drop")

  15. 60 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Reopening this item since we have additional votes and heard about more comments related to this.
    Few comments/workaround in the meantime:
    - For PII/HBI data: ASA on IoT Edge and Azure Stack for PII – this allows pre-processing at the Edge without sending data to the cloud.
    - Streaming + DB can work side-by-side on ASDE (Azure SQL Database Edge)

    Thank you for your interest in using Stream Analytics. We are looking for more details on this scenario. For those of you that are interested in an input for On-prem SQL, are you looking to use the SQL data as reference data to be joined with another incoming data stream? Or looking to using the SQL data as a data stream? In the reference data case, you can use Azure Data Factory to take periodic snapshots of the relevant reference data and copy it to blobs that can then be used by Azure Stream Analytics.

    For those of you looking for a direct output to On-Prem SQL, while we don't yet support this scenario directly, it is possible as a workaround to use Azure SQL DB as an output from Stream Analytics and setup a scheduled data move using Azure Data Factory to move the data from Azure DB to your On-Prem SQL database and accomplish a similar pattern.

  16. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for reaching out Hamid.

    Can you clarify? Are you suggesting that Azure Stream Analytics directly pull from sources such as the Twitter firehose? What would pulling from a device mean?

    Thanks!

  17. 46 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Does DateTimeFromParts work for you?

    https://msdn.microsoft.com/en-us/library/azure/dn835025.aspx

    If not, then please let us know why not.

  18. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you Gökhan for the reply and valuable feedback. Let us look into this suggestion.

  19. 13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    While we are considering further output targets, please note that we support Azure Storage Tables and Azure DocumentDB today - both of which qualify as NoSQL stores.

  20. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    ASA does not support an outer join with reference data today.

← Previous 1

Feedback and Knowledge Base