Inspecting s-Server Objects in s-Studio
The s-Studio Development pane lists the following objects:
|•||Schemas. Schemas can include foreign streams, foreign tables, streams, tables, user defined functions and view. All of these objects, including schemas, are created and maintained with SQL.|
|•||Data Sources and Sinks. These include all server objects that have been created using the CREATE SERVER command.|
|•||Plugins. This is a standard list of pre-installed plugins: AMQP, ECDA, FileWriter, HTTP, Log4j, LogFile, Mail, NetworkSocket, TableReader, TableUpdate, and WebFeed.|
You can view details on any object by clicking it in the development pane. For example, the diagram below shows a data source (a server) that reads from the file system. Details about this adapter, in this case its plugin and description, appear in the Inspection window. You can modify some fields through this window.
You can view the data in any stream, table, or view from within SQLstream s-Studio. For a regular table or relational view, this is the same as selecting all the data from the table:
For a stream, the inspection window shows all rows as they pass through the stream. The inspection window - like any stream query - only sees rows arriving after the start of the query. Here is an example from the The Edamame Demo.
In all cases, inspecting executes a query of SELECT * FROM <object> or SELECT STREAM ROWTIME, * FROM <object> for streams. This is a convenient way to monitor data flowing in your applications or to test data flows while developing.