Azure Stream Analytics service makes it easy to ingest, process, and analyze streaming data from an events source (Event Hub/IoT Hub/Blob Storage), enabling powerful insights to drive real-time actions. But before you publish your Stream Analytics query to cloud to run 24x7, do you know you can test your query 3 different ways?
Here are the key benefits of testing your query:
1. Azure Portal | 2. VS Code | 3. Visual Studio | |
Platform type | Web client | Editor | IDE |
Query execution | Test runs in the cloud without charge |
Test runs on your machine |
Test runs on your machine |
Test scenario 1 Local data (JSON/CSV)
|
Yes | Yes | Yes |
Test scenario 2 Sample data
|
Yes (Event Hub, IoT Hub, Blob Storage)
SQL reference data supported |
No | No |
Test scenario 3 Live data
|
No |
Yes (Event Hub, IoT Hub, Blob Storage)
Blob/SQL reference data supported |
Yes (Event Hub, IoT Hub, Blob Storage)
Blob/SQL reference data supported |
Job diagram availability while testing the query |
No |
Yes You can view the data & metrics of each query step in each intermediate result set to find the source of an issue.
|
Yes You can view the data & metrics of each query step in each intermediate result set to find the source of an issue. |
Documentation | Job diagram | ||
Limitations |
No support for Event ordering in testing.
C# UDFs and deserializers not supported.
Queries with <1 min execution time are supported for testing. |
Support for Event ordering.
C# UDFs and deserializers support expected by end of year. |
Support for Event ordering
C# UDFs and deserializers are supported. |
Query testing should only be used for functional testing purposes. It does not replace the performance and scalability tests you would perform in the cloud. This testing feature should not be used for production purposes since running in a local environment doesn’t guarantee any service SLA.
Engage with us and get early glimpses of new features by following us on Twitter at @AzureStreaming.
The Azure Stream Analytics team is highly committed to listening to your feedback and letting the user's voice influence our future investments. We welcome you to join the conversation and make your voice heard via our UserVoice page
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.