Skip to main content
IN PREVIEW

Public preview: SQL DB output connector improvements in Stream Analytics

Published date: July 26, 2022

You can now configure your Azure Stream Analytics job to write to a table in your Azure SQL Database that hasn't yet been created. You have to do the following steps:

  1. Make sure that there is incoming streaming data in your Azure Stream Analytics job
  2. Write your Stream Analytics query (or use the existing template of Select *)
  3. Test your Stream Analytics query
  4. Select "Create table" - Stream Analytics will use the schema from Step 3 to create a new table in your SQL Database.

 

You can also see schema mismatch detection if you want to write output of Stream Analytics query to an existing SQL table. This will prevent job failures due to data/schema mismatch errors. You have to do the following steps:

  1. Make sure that there is incoming streaming data in your Azure Stream Analytics job
  2. Write your Stream Analytics query (or use the existing template of Select *)
  3. Test your Stream Analytics query
  4. Check whether the incoming data type and selected SQL table match or not. If it's not a match, you'll be prompted to update your query to match SQL table schema.

To learn more, visit Write to Azure SQL Database table from your Azure Stream Analytics jobs.

  • Azure Stream Analytics
  • Features

Related Products