Azure Synapse Analytics Cookbook by Gaurav Agarwal | Meenakshi Muralidharan

Author:Gaurav Agarwal | Meenakshi Muralidharan
Language: eng
Format: epub
Publisher: Packt Publishing Pvt Ltd
Published: 2022-04-13T00:00:00+00:00

Query the view with the select statement to find out how many temperatures have been recorded inside and outside the rooms: select location, count(*) as count from IOTTEMP group by location

The results can be viewed as follows.

Figure 4.25 – Results window

Now, analyze the real-time data interactively and create charts to understand the data:select DAY(CONVERT(DATETIME,noted_date,103)) AS 'Days in October', temp from IOTTEMP order by 'Days in October'

Click Chart in the results and a line chart will be generated, as shown in the following screenshot of the Synapse Studio SQL script Results window.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.