Inspecting s-Server Objects in s-Studio

<< Click to Display Table of Contents >>

Navigation:  Using s-Studio >

Inspecting s-Server Objects in s-Studio

Previous pageReturn to chapter overviewNext page

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.

std_inspecting_studio_objects

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 from the The Edamame Demo.

ui_inspectloginsJEL

Inspecting Rows from a Stream

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.