2

How to make Stream Analytics output shown in Azure SQL database, do I have to create a new table? If so, what data name and type should I input, refering to Raspberry Pi Azure IoT Web Simulator https://azure-samples.github.io/raspberry-pi-web-simulator/

I'm new to Azure iot and Stream Analytics. Currently I'm using Raspberry Pi Azure IoT Web Simulator as a learning material, I followed Microsoft doc and succeeded making the simulator message shown in the blob of storage account.

Improve this question

1 Answer 1

Reset to default
1

How to make Stream Analytics output shown in Azure SQL database, do I have to create a new table? If so, what data name and type should I input

Yes,you need to create tables in Azure Sql Database so that you could configure that as output.

enter image description here

You could follow this official document to configure the output in Azure Stream Analytics.

Since you already have input data, then just use the output alias in the query sql to parse the data. The input data types need to match the output column data types.

enter image description here

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

2 Comments

Thanks alot, my sql db is receiving messages : 3
@Chen Glad for you!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.