%3CLINGO-SUB%20id%3D%22lingo-sub-1655369%22%20slang%3D%22en-US%22%3ETest%20your%20Azure%20Stream%20Analytics%20query%20in%203%20ways%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655369%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Stream%20Analytics%20service%20makes%20it%20easy%20to%20ingest%2C%20process%2C%20and%20analyze%20streaming%20data%20from%20an%20events%20source%20(Event%20Hub%2FIoT%20Hub%2FBlob%20Storage)%2C%20enabling%20powerful%20insights%20to%20drive%20real-time%20actions.%20But%20before%20you%20publish%20your%20Stream%20Analytics%20query%20to%20cloud%20to%20run%2024x7%2C%20do%20you%20know%20you%20can%20test%20your%20query%203%20different%20ways%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1229465966%22%20id%3D%22toc-hId-1229465994%22%3E%3CSTRONG%3EBenefits%20of%20testing%20the%20query%20%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EHere%20are%20the%20key%20benefits%20of%20testing%20your%20query%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EDevelopment%20productivity%3C%2FSTRONG%3E%3A%20Fast%20iteration%20to%20test%20and%20fix%20the%20query%20in%20a%20single%20box%20environment%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ETest%20before%20deploying%3C%2FSTRONG%3E%3A%20You%20can%20test%20the%20query%20logic%20with%20live%20data%20or%20local%20data%20without%20deploying%20to%20the%20cloud%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EQuery%20behavior%20consistency%3C%2FSTRONG%3E%3A%20For%20live%20input%2C%20the%20queries%20will%20output%20the%20same%20results%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EFast%20results%3C%2FSTRONG%3E%3A%20You%20can%20view%20query%20results%20in%20%26lt%3B%204seconds%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EFree%3C%2FSTRONG%3E%3A%20Test%20your%20query%20for%20free%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--577988497%22%20id%3D%22toc-hId--577988469%22%3E%3CSTRONG%3E%3CSPAN%20style%3D%22font-family%3A%20'Segoe%20UI%20Semilight'%2Csans-serif%3B%22%3EHere%20are%203%20ways%20you%20can%20test%20your%20query%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CSTRONG%3E1.%20Azure%20Portal%3C%2FSTRONG%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CSTRONG%3E2.%20VS%20Code%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CSTRONG%3E3.%20Visual%20Studio%3C%2FSTRONG%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CEM%3EPlatform%20type%3C%2FEM%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3EWeb%20client%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3EEditor%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3EIDE%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CEM%3EQuery%20execution%3C%2FEM%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3ETest%20runs%20in%20the%20cloud%20without%20charge%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%3E%3CP%3ETest%20runs%20on%20your%20machine%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%3E%3CP%3ETest%20runs%20on%20your%20machine%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CEM%3ETest%20scenario%201%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3ELocal%20data%20(JSON%2FCSV)%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EYou%20can%20test%20your%20Stream%20Analytics%20query%20by%20using%20a%20local%20file.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3EYes%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3EYes%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3EYes%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CEM%3ETest%20scenario%202%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3ESample%20data%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EYou%20can%20test%20your%20Stream%20Analytics%20query%20against%20snapshot%2Fsample%20of%20live%20stream%20input.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3EYes%3C%2FP%3E%0A%3CP%3E(Event%20Hub%2C%20IoT%20Hub%2C%20Blob%20Storage)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESQL%20reference%20data%20supported%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3ENo%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3ENo%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CEM%3ETest%20scenario%203%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3ELive%20data%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EYou%20can%20test%20your%20Stream%20Analytics%20query%20against%20live%20stream%20input.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3ENo%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3EYes%3C%2FP%3E%0A%3CP%3E(Event%20Hub%2C%20IoT%20Hub%2C%20Blob%20Storage)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBlob%2FSQL%20reference%20data%20supported%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3EYes%3C%2FP%3E%0A%3CP%3E(Event%20Hub%2C%20IoT%20Hub%2C%20Blob%20Storage)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBlob%2FSQL%20reference%20data%20supported%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CEM%3EJob%20diagram%20availability%20%3C%2FEM%3Ewhile%20testing%20the%20query%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3ENo%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3EYes%3C%2FP%3E%0A%3CP%3EYou%20can%20view%20the%20data%20%26amp%3B%20metrics%20of%20each%20query%20step%20in%20each%20intermediate%20result%20set%20to%20find%20the%20source%20of%20an%20issue.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3EYes%3C%2FP%3E%0A%3CP%3EYou%20can%20view%20the%20data%20%26amp%3B%20metrics%20of%20each%20query%20step%20in%20each%20intermediate%20result%20set%20to%20find%20the%20source%20of%20an%20issue.%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CEM%3EDocumentation%3C%2FEM%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-test-query%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELocal%20data%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-test-query%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESample%20data%3C%2FA%3E%3C%2FP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-job-diagram-with-metrics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EJob%20diagram%3C%2FA%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fvisual-studio-code-local-run%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELocal%20data%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fvisual-studio-code-local-run-live-input%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELive%20data%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fdebug-locally-using-job-diagram-vs-code%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EJob%20diagram%3C%2FA%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-vs-tools-local-run%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELocal%20data%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-live-data-local-testing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELive%20data%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fdebug-locally-using-job-diagram%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EJob%20diagram%3C%2FA%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%3CEM%3ELimitations%3C%2FEM%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%20support%20for%20Event%20ordering%20in%20testing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC%23%20UDFs%20and%20deserializers%20not%20supported.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3ELocal%20input%20size%20%26lt%3B2%20MB%20for%20testing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3EQueries%20with%20%26lt%3B1%20min%20execution%20time%20are%20supported%20for%20testing.%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3ESupport%20for%20Event%20ordering.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC%23%20UDFs%20and%20deserializers%20%26nbsp%3Bsupport%20expected%20by%20end%20of%20year.%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2225%25%22%20height%3D%2230px%22%3E%3CP%3ESupport%20for%20Event%20ordering%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC%23%20UDFs%20and%20deserializers%20are%20supported.%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CH2%20id%3D%22toc-hId--588491601%22%20id%3D%22toc-hId--588491573%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-102069873%22%20id%3D%22toc-hId-102069901%22%3E%3CSTRONG%3E1.%20Azure%20Portal%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217683i014F0D7916C42C94%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Picture1.png%22%20alt%3D%22Test%20your%20query%20in%20Azure%20portal%20by%20using%20a%20local%20file%20or%20sample%20of%20live%20data%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ETest%20your%20query%20in%20Azure%20portal%20by%20using%20a%20local%20file%20or%20sample%20of%20live%20data%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1705384590%22%20id%3D%22toc-hId--1705384562%22%3E%3CSTRONG%3E2.%20VS%20Code%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22VS%20Code%20testing%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217673i54E97C9650C189DB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22VS%20Code%20testing%201.png%22%20alt%3D%22Test%20your%20query%20in%20VS%20Code%20by%20using%20a%20local%20file%20or%20live%20data%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ETest%20your%20query%20in%20VS%20Code%20by%20using%20a%20local%20file%20or%20live%20data%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22VS%20Code%20testing%202.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217674iF8A120E01EFCD16C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22VS%20Code%20testing%202.png%22%20alt%3D%22Use%20Job%20Diagram%20to%20see%20intermediate%20results%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EUse%20Job%20Diagram%20to%20see%20intermediate%20results%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-782128243%22%20id%3D%22toc-hId-782128271%22%3E%3CSTRONG%3E3.%20Visual%20Studio%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Visual%20Studio%20testing.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217675iE826759158C3B34F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Visual%20Studio%20testing.png%22%20alt%3D%22Test%20your%20query%20in%20VS%20Code%20by%20using%20a%20local%20file%20or%20live%20data%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ETest%20your%20query%20in%20VS%20Code%20by%20using%20a%20local%20file%20or%20live%20data%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQuery%20testing%20should%20only%20be%20used%20for%20functional%20testing%20purposes.%20It%20does%20not%20replace%20the%20performance%20and%20scalability%20tests%20you%20would%20perform%20in%20the%20cloud.%20This%20testing%20feature%20should%20not%20be%20used%20for%20production%20purposes%20since%20running%20in%20a%20local%20environment%20doesn%E2%80%99t%20guarantee%20any%20service%20SLA.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1025326220%22%20id%3D%22toc-hId--1025326192%22%3E%3CSTRONG%3EFeedback%20and%20engagement%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EEngage%20with%20us%20and%20get%20early%20glimpses%20of%20new%20features%20by%20following%20us%20on%20Twitter%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FAzureStreaming%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%40AzureStreaming%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3EThe%20Azure%20Stream%20Analytics%20team%20is%20highly%20committed%20to%20listening%20to%20your%20feedback%20and%20letting%20the%20user's%20voice%20influence%20our%20future%20investments.%20We%20welcome%20you%20to%20join%20the%20conversation%20and%20make%20your%20voice%20heard%20via%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ffeedback.azure.com%2Fforums%2F270577-stream-analytics%2Ffilters%2Ftop%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUserVoice%20page%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1655369%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Stream%20Analytics%20service%20makes%20it%20easy%20to%20ingest%2C%20process%2C%20and%20analyze%20streaming%20data%20from%20an%20events%20source%20(Event%20Hub%2FIoT%20Hub%2FBlob%20Storage)%2C%20enabling%20powerful%20insights%20to%20drive%20real-time%20actions.%20But%20before%20you%20publish%20your%20Stream%20Analytics%20query%20to%20cloud%20to%20run%2024x7%2C%20do%20you%20know%20you%20can%20test%20your%20query%203%20different%20ways%3F%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1655369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Stream%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

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?

 

Benefits of testing the query

Here are the key benefits of testing your query:

  • Development productivity: Fast iteration to test and fix the query in a single box environment
  • Test before deploying: You can test the query logic with live data or local data without deploying to the cloud
  • Query behavior consistency: For live input, the queries will output the same results
  • Fast results: You can view query results in < 4seconds
  • Free: Test your query for free

 

Here are 3 ways you can test 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)

  • You can test your Stream Analytics query by using a local file.
Yes Yes Yes

Test scenario 2

Sample data

  • You can test your Stream Analytics query against snapshot/sample of live stream input.

Yes

(Event Hub, IoT Hub, Blob Storage)

 

SQL reference data supported

No No

Test scenario 3

Live data

  • You can test your Stream Analytics query against live stream input.
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

Local data

Sample data

Job diagram

Local data

Live data

Job diagram

Local data

Live data

Job diagram

Limitations

 

No support for Event ordering in testing.

 

C# UDFs and deserializers not supported.


Local input size <2 MB for testing.

 

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.

 

 

1. Azure Portal

Test your query in Azure portal by using a local file or sample of live dataTest your query in Azure portal by using a local file or sample of live data

 

2. VS Code

Test your query in VS Code by using a local file or live dataTest your query in VS Code by using a local file or live data

 

Use Job Diagram to see intermediate resultsUse Job Diagram to see intermediate results

 

3. Visual Studio

Test your query in VS Code by using a local file or live dataTest your query in VS Code by using a local file or live data

 

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.

 

Feedback and engagement

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