The stream inspection studio

SQLstream s-Studio is SQLstream’s Integrated Development Environment. It provides access to all the objects defined in an instance of the SQLstream s-Server, including streams, tables, views, adapters, and pumps.  Using s-Studio, you can create, delete, view, or edit SQL object definitions (such as streams, foreign tables, and views) as well as inspect streaming data in real time. It lets you develop, test, run, and administer streaming SQL applications.

The Catalog tab displays s-Server objects. Most objects–streams, tables, functions, views, and pumps–appear under schemas.

Whenever SQLstream s-Studio is connected to the server, ad-hoc SQL queries can be issued against the server, with immediately visible results.

Data is visible 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 Edamame Demo.

Often, when testing an application, you need to provide data for a stream to test downstream objects, particularly aggregations and JOINs. Normally, to handle this you have to either run a script or use an external tool to execute INSERT SQL statements.

SQLstream s-Studio provides an easy way to inject proper test data into a stream or foreign table.