Azure Stream Analytics: SQL Output not working

Question

Context

I use an Azure Stream Analytics Job to process streaming data and output the results to a SQL table. The user I use has the db_datawriter role assigned on the Azure SQL DB.

Issue

There is no output to the SQL DB Table. I also tested the query together with a Blob output (what is working well) as well as checked all columns for having the right data types and order. Also the connection tests are successful and no errors are shown in the Activity Log.

Question

Why is then no output generated for the SQL output?

quervernetzt · Accepted Answer · 2019-03-19 08:00:29Z

2

The issue is a lack of permissions. When I additionally assign the

db_datareader

role to the user it works fine.

answered Mar 19, 2019 at 8:00

quervernetzt

12k7 gold badges41 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Azure Stream Analytics: SQL Output not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related