DataService Studio's SQL analysis feature enables the examination of data reported by devices to the IoT Platform and the performance of association analysis on imported industry and business data. It allows users to craft SQL statements to set query execution policies and schedule data outputs as needed.
Feature description
Create SQL analysis tasks to utilize data from data storage tables as query subjects, configure tasks with SQL statements, and schedule the delivery of desired data to custom storage tables. This lays the groundwork for further exploration of data value. SQL analysis tasks can be initiated on the IoT Platform console within the corresponding instance on the DataService Studio > Analysis Insights page.
What to do next
Once the SQL analysis task is published, you can monitor and manage it to keep track of its scheduling status.
After the SQL analysis task is scheduled:
The resulting custom storage tables can be found in Data Storage under Offline Storage within Customized Storage Tables.
These tables can serve as data sources for data API applications.