Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Stream Analytics

Azure Stream Analytics is a fully managed real-time stream computation service hosted in Microsoft Azure, which provides highly resilient, low latency, and scalable complex event processing of streaming data. Azure Stream Analytics enables developers to easily combine streams of data with historic records or reference data to derive business insights easily and quickly.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Solr as output

    would be nice to have Solr as an Output for a job

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. New output sink LogicApp would be nice...

    To be flexible to do what ever we like to do... (alerting via Mail, SMS ...)

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. no event for reference

    Hi,

    I look for to count event appear in period of time for a device reference list, using :
    SELECT
    t2.id,
    count(t1.[TimeStamp]) as nbEvents
    FirstTime
    FROM
    [IotHubInput] t1 TIMESTAMP BY [TimeStamp]
    join [DevicesList] t2 on t2.id = t1.id
    group by
    t2.id,
    TumblingWindow(hour,5)

    Give me only count for present device. I would like to have result 0 for device present in reference.
    Can't put deviceList in first or join option to have all lines from t2 (like in SQLServer)

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. percentile

    Provide easy Percentile functions such as PERCENTILE(foo, 95) in ASA queries

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Service Bus Relay as output

    Add service bus relay as an output

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Optional Columns in Query

    Currently, when processing events from an Event Hub and using a 'CREATE TABLE' statement in the Stream Analytics Query, all specified fields must be present in the event. Otherwise, a 'FieldsMismatchError' is encountered.

    "Message:Missing fields specified in query or in create table.
    Fields expected: {list of fields in CREATE TABLE statement}
    Fields found: {list of fields in event}
    Missing fields: {list of missing fields} Type:FieldsMismatchError Correlation ID:"{GUID}"

    I would like to be able to use a 'CREATE TABLE' statement specifying optional fields, f.e. as following;

    CREATE TABLE
    tablename
    ( column
    name <data_type> [ NULL | NOT NULL ] […

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add Cassandra to output

    Add Cassandra as an option to output.
    Cassandra (DataStaxEnterprise) offer a high performance queries on Azure

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Output to a custom metric

    Allow a scalar value to be output to a custom metric on the Stream Analytics [SA] dashboard. This gives us a really easy way to connect aggregated statistics on our data into the existing monitoring and alerting capabilities of SA.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Stream into existing Power BI Datasets

    Hey,
    it would be great to have the possibility to create a dataset in PowerBi Desktop and use as output in ASA.

    112 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. allow APPLY statement for reference data that arrives as nested array

    a current workaround is to send a field that contains the index of each item to be able to do a JOIN.
    if APPLY would be possible, it would be much easier to read value and index directly from the array.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Conversion errors

    When a conversion error happens it would be great to to know wich column was the error source.

    Encountered error trying to write 1 event(s): Conversion from 'System.Int16' to 'System.String' failed.

    is not very helpful

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Need to have output back to IoT Hub

    Need to have output to IoT Hub

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. mongo

    Add an output to a MongoDb collection. So Stream Analytics can store information into a NoSql Document based DB, such as MongoDB.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. (Preview Portal) display JSON format error

    When input data format is set JSON and event data format is not correct , error message isn't displayed in preview portal.
    But Normal portal is displayed warning as the following.

    "Could not deserialize the input event as Json. Some possible reasons: 1) Malformed events 2) Input source configured with incorrect serialization format"

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. Active (auto-learning) dimensional lookups

    When taking events form external entities and manipulating them for String based dimensions from the sources need to be converted into dimension keys for storing in Azure SQL DW. However, in an adaptive system, new dimensions need to be learnt (added) on the fly so a writeback mechanism needs to be supported. Without this the columnstores in the DW would be string based, bloated and lack performance.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. notification hub as output

    Can we add Notification Hub as output to Stream Analytics

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. Input from a redis cache/queue

    It would be great if Azure Redis could be configured as an input source.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Stream Analytics

Categories

Feedback and Knowledge Base