Documentation

1. Azure Stream Analytics documentation
2. Overview
    2.1. What is Stream Analytics?
    2.2. Stream Analytics Cluster
3. Quickstarts
    3.1. Create a job
        3.1.1. Azure portal
        3.1.2. Azure CLI
        3.1.3. ARM template
        3.1.4. PowerShell
        3.1.5. Visual Studio
        3.1.6. Visual Studio Code
    3.2. Create a cluster
        3.2.1. Azure portal
4. Tutorials
    4.1. 1 - Create / manage a job
    4.2. 2 - Run Azure Functions
    4.3. 3 - Deploy with CI/CD in Azure Pipelines
    4.4. 4 - Run a C# UDF
    4.5. 5 - Create custom .NET deserializer
5. Samples
    5.1. Code samples
6. Concepts
    6.1. End-to-end solution patterns
    6.2. Choose a streaming analytics technology
    6.3. Choose a job development tool
    6.4. Develop locally
    6.5. Security
        6.5.1. Security controls by Azure Policy
        6.5.2. Security baseline
    6.6. Input types for a job
        6.6.1. Inputs overview
        6.6.2. Streaming data inputs
        6.6.3. Reference data inputs
        6.6.4. Read inputs in any format using custom deserializers
    6.7. Output types for a job
        6.7.1. Outputs overview
        6.7.2. Azure Data Lake Storage Gen 1
        6.7.3. Azure SQL Database
        6.7.4. SQL Database performance
        6.7.5. Azure Synapse Analytics
        6.7.6. Blob storage & Azure Data Lake Gen 2
        6.7.7. Blob custom path patterns
        6.7.8. Event Hubs
        6.7.9. Power BI
        6.7.10. Table storage
        6.7.11. Service Bus queues
        6.7.12. Service Bus topics
        6.7.13. Azure Cosmos DB
        6.7.14. Cosmos DB optimization
        6.7.15. Azure Functions
    6.8. Extend queries with functions
        6.8.1. Functions overview
        6.8.2. JavaScript UDF
        6.8.3. JavaScript UDA
        6.8.4. C# UDF
        6.8.5. Machine learning UDF
        6.8.6. Debug UDFs
    6.9. Optimize your Stream Analytics job
        6.9.1. Understand and adjust Streaming Units
        6.9.2. Improve query performance
        6.9.3. Repartition your input
        6.9.4. Increase throughput of your job
    6.10. States of a job
    6.11. Window functions
    6.12. Geospatial functions
    6.13. Compatibility level
    6.14. Common query patterns
    6.15. Parse JSON and AVRO data
    6.16. Time handling considerations
    6.17. Checkpoint and replay
    6.18. Error policy
7. How-to guides
    7.1. Manage
        7.1.1. Clusters
            7.1.1.1. Create and delete private endpoints
            7.1.1.2. Add and remove jobs
            7.1.1.3. Scale cluster size
        7.1.2. Autoscale jobs
        7.1.3. Update credentials
        7.1.4. Configure event ordering policies
        7.1.5. Configure alerts
        7.1.6. Start a job
        7.1.7. Test a job
        7.1.8. View results on a dashboard
        7.1.9. Stop or delete a job
        7.1.10. Copy or back up a job
        7.1.11. Pair jobs for reliability
        7.1.12. Use SQL reference data
        7.1.13. Authenticate with managed identity
            7.1.13.1. ADLS Gen 1
            7.1.13.2. Blob storage
            7.1.13.3. Power BI
            7.1.13.4. Azure SQL DB
        7.1.14. Encrypt your data
        7.1.15. Geo-redundancy
    7.2. Build solutions
        7.2.1. Twitter sentiment analysis
        7.2.2. Real-time fraud detection
        7.2.3. Run jobs on IoT Edge
        7.2.4. Run jobs on Azure Stack
        7.2.5. Toll booth sensor data analysis
        7.2.6. High-frequency trading
        7.2.7. Process IoT streaming data
        7.2.8. Threshold-based rules
        7.2.9. Process Kafka events
        7.2.10. Process Event Hubs data
        7.2.11. Process Azure SQL Database
        7.2.12. Geospatial scenarios
    7.3. Monitor
        7.3.1. Monitor jobs- Azure portal
        7.3.2. Monitor jobs- PowerShell
        7.3.3. Monitor jobs- Azure .NET SDK
        7.3.4. Monitor jobs- Visual Studio
    7.4. Automate
        7.4.1. Using .NET SDK
        7.4.2. Using Azure PowerShell
        7.4.3. Using API for IoT Edge jobs
        7.4.4. Export and deploy with Azure Resource Manager
    7.5. Continuous integration and deployment
        7.5.1. CI/CD overview
        7.5.2. Build, test, and deploy with PowerShell
        7.5.3. Set up a pipeline with Azure DevOps
    7.6. Visual Studio
        7.6.1. Install tools
        7.6.2. Test locally with sample data
        7.6.3. Test locally with live data
        7.6.4. View jobs in Visual Studio
        7.6.5. Debug queries using job diagram
        7.6.6. Develop an edge job
        7.6.7. Set up CI/CD pipeline
    7.7. Visual Studio Code
        7.7.1. Complete code with IntelliSense
        7.7.2. Test locally with sample data
        7.7.3. Test locally with live data
        7.7.4. Debug queries using job diagram
        7.7.5. Explore jobs
        7.7.6. JobConfig.json fields
    7.8. Troubleshoot
        7.8.1. Input
        7.8.2. Output
        7.8.3. Query logic
        7.8.4. Activity and resource logs
        7.8.5. Data errors
        7.8.6. Error codes
            7.8.6.1. Configuration errors
            7.8.6.2. Data errors
            7.8.6.3. External availability errors
            7.8.6.4. External errors
            7.8.6.5. Internal errors
    7.9. Integrate with machine learnings
        7.9.1. Sentiment analysis with ML models
        7.9.2. Anomaly detection
        7.9.3. Use REST APIs
    7.10. Debug using job diagram
    7.11. Scale with ML functions
8. Stream Analytics Query Language
    8.1. Stream Analytics Query Language overview
    8.2. Built-in Functions
        8.2.1. Built-in Functions Overview
        8.2.2. Aggregate Functions
            8.2.2.1. Aggregate Functions Overview
            8.2.2.2. AVG
            8.2.2.3. COUNT
            8.2.2.4. Collect
            8.2.2.5. CollectTOP
            8.2.2.6. MAX
            8.2.2.7. MIN
            8.2.2.8. Percentile_Cont
            8.2.2.9. Percentile_Disc
            8.2.2.10. STDEV
            8.2.2.11. STDEVP
            8.2.2.12. SUM
            8.2.2.13. TopOne
            8.2.2.14. VAR
            8.2.2.15. VARP
        8.2.3. Analytic Functions
            8.2.3.1. Analytic Functions Overview
            8.2.3.2. AnomalyDetection_SpikeAndDip
            8.2.3.3. AnomalyDetection_ChangePoint
            8.2.3.4. ISFIRST
            8.2.3.5. LAG
            8.2.3.6. LAST
        8.2.4. Array Functions
            8.2.4.1. Array Functions Overview
            8.2.4.2. GetArrayLength
            8.2.4.3. GetArrayElement
            8.2.4.4. GetArrayElements
        8.2.5. Conversion Functions
            8.2.5.1. Conversion Functions Overview
            8.2.5.2. CAST
            8.2.5.3. GetType
            8.2.5.4. TRY_CAST
        8.2.6. Date and Time Functions
            8.2.6.1. Date and Time Functions Overview
            8.2.6.2. DATEADD
            8.2.6.3. DATEDIFF
            8.2.6.4. DATENAME
            8.2.6.5. DATEPART
            8.2.6.6. DATETIMEFROMPARTS
            8.2.6.7. DAY
            8.2.6.8. MONTH
            8.2.6.9. YEAR
        8.2.7. GeoSpatial Functions
            8.2.7.1. GeoSpatial Functions Overview
            8.2.7.2. CreateLineString
            8.2.7.3. CreatePoint
            8.2.7.4. CreatePolygon
            8.2.7.5. ST_DISTANCE
            8.2.7.6. ST_OVERLAPS
            8.2.7.7. ST_INTERSECTS
            8.2.7.8. ST_WITHIN
        8.2.8. Input Metadata Functions
            8.2.8.1. Input Metadata Functions Overview
            8.2.8.2. GetMetadataPropertyValue
        8.2.9. Mathematical Functions
            8.2.9.1. Mathematical Functions Overview
            8.2.9.2. ABS
            8.2.9.3. CEILING
            8.2.9.4. EXP
            8.2.9.5. FLOOR
            8.2.9.6. POWER
            8.2.9.7. ROUND
            8.2.9.8. SIGN
            8.2.9.9. SQUARE
            8.2.9.10. SQRT
        8.2.10. Record Functions
            8.2.10.1. Record Functions Overview
            8.2.10.2. GetRecordProperties
            8.2.10.3. GetRecordPropertyValue
        8.2.11. String Functions
            8.2.11.1. String Functions Overview
            8.2.11.2. CHARINDEX
            8.2.11.3. CONCAT
            8.2.11.4. LEN
            8.2.11.5. LOWER
            8.2.11.6. PATINDEX
            8.2.11.7. REGEXMATCH
            8.2.11.8. REPLACE
            8.2.11.9. SUBSTRING
            8.2.11.10. UPPER
        8.2.12. Windowing Functions
            8.2.12.1. Windowing Functions Overview
            8.2.12.2. Hopping Window
            8.2.12.3. Session Window
            8.2.12.4. Sliding Window
            8.2.12.5. Tumbling Window
            8.2.12.6. Aggregate Windowing functions
    8.3. Data Types
        8.3.1. Data Types Overview
        8.3.2. Parsing JSON and AVRO data
    8.4. Query Language Elements
        8.4.1. Query Language Elements Overview
        8.4.2. APPLY
        8.4.3. CASE
        8.4.4. COALESCE
        8.4.5. CREATE TABLE
        8.4.6. FROM
        8.4.7. GROUP BY
        8.4.8. HAVING
        8.4.9. INTO
        8.4.10. JOIN
        8.4.11. MATCH_RECOGNIZE
        8.4.12. Reference Data JOIN
        8.4.13. SELECT
        8.4.14. UNION
        8.4.15. WHERE
        8.4.16. WITH
    8.5. Time Management
        8.5.1. Time Management Overview
        8.5.2. System.Timestamp
        8.5.3. TIMESTAMP BY
        8.5.4. Time Skew Policies
    8.6. Event Delivery Guarantees
9. Reference
    9.1. Azure PowerShell
    9.2. .NET
    9.3. REST
    9.4. Resource Manager template
    9.5. Azure CLI
    9.6. Azure Policy built-ins
10. Resources
    10.1. Stream Analytics previews
    10.2. Azure Roadmap
    10.3. Blog
    10.4. Feedback forum
    10.5. Microsoft Q&A question page
    10.6. Pricing
    10.7. Pricing calculator
    10.8. Service updates
    10.9. Stack Overflow
    10.10. Videos
    10.11. Customer case studies
    10.12. Whitepaper - Real-time event processing