How to configure a SQL database as an output of Stream Analytics

Javier Familiar Gijon 40 Reputation points
2023-05-10T13:29:05.2133333+00:00

I tried the tutorial of blob storage and I adapt it with sql database but I didn´t get it

Azure SQL Database
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
339 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,222 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,186 Reputation points Microsoft Employee
    2023-05-10T14:48:11.89+00:00

    Hi Javier Familiar Gijon •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand from the question, you want to configure Azure SQL Database as an Output in Azure Stream Analytics job.

    In standard Microsoft documentation, we have a documentation in place for: Write to Azure SQL Database table from your Azure Stream Analytics jobs.

    It states the prerequisites and steps to configure the same.

    It's important to ensure that the output of your Stream Analytics job matches the column names and data types expected by your SQL Database table. If there's a mismatch, your job will run into data conversion errors, and continuously retry until the SQL table definition is changed. You can change your job’s behavior to drop such output that cause data conversion errors and proceed to the next one.

    Other helpful links: https://stackoverflow.com/questions/54436644/how-to-get-azure-stream-analytics-output-into-an-azure-sql-db

    https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-sql-output-perf

    Please refer to the document and let us know if you face any issue.

    Thank you.

    1 person found this answer helpful.
    0 comments No comments