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.

Inspecting Stream Contents

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:

Inspecting Rows from a Stream

In all cases, inspecting executes a query of SELECT * FROM or SELECT STREAM ROWTIME, * FROM for streams. This is a convenient way to monitor data flowing in your applications or to test data flows while developing.