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

Question

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

Answer 1

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.