Reputation: 181
How to get Azure Stream Analytics output into an Azure SQL DB
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.
Upvotes: 2
Views: 2424
Answers (1)
Reputation: 23782
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.
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.
Upvotes: 1
Related Questions
- Stream Analytics doesn't output the data to SQL but does to a blob storage
- Stream output data from Stream Analytics Job to Azure Synapse Analytics sql pool table?
- Store data into SQL database from Azure IoTHub using Azure Functions without Stream Analytics
- Azure Stream Analytics output to Azure Cosmos DB
- Azure Stream Analytics: SQL Output not working
- How can I use Azure Stream Analytics to use an on-premise SQL Server as an Output?
- azure stream analytics to cosmos db
- Stream Analytics Query working but no output to table
- Write Azure stream analytics output to Azure Tables
- is there a way to write stream analytics output to Azure documentdb