StreamLab Guides Overview

<< Click to Display Table of Contents >>

Navigation:  Using StreamLab >

StreamLab Guides Overview

Previous pageReturn to chapter overviewNext page

Guides are collections of commands, suggestions, and scripts that let you create views on data sources. These views are composed of SQL; you use the Guide interface to generate this SQL. You use guides to prep sources for dashboards. You can also use guides to run analytics on streaming sources.

For example, you might have a guide that extracted the year (often the first four characters) from a timestamp column and added these to a new column called YEAR. Other guides might split a column, rename it, merge two, and so on. You might also have a guide that adds a running average column.

Commands

Commands are sets of operations that you can perform on the guide's data source. These include, for example, commands to parse the source as a W3C log, to parse a timestamp, to split a column at a given character, to remove a column, and to rename a column. Commands are grouped by functionality, and you can switch between command sets by clicking the Select Command Set button in the top left hand corner of the Guide.

sl_guide_commands

Suggestions

Suggestions appear in the Suggestions list in the middle left of the Guide interface. Suggestions change depending on your data source and your selection in the Output view.

sl_guide_suggestions

Scripts

As you add suggestions to the script, these suggestions are implemented as SQL, with changes visible in the Output view. You can remove items from the script by clicking the - button. You can also visualize changes by clicking the View Dashboard button sl_guide_view_dashboard_button.

sl_guide_script

Viewing the Log

You can view the SQL generated by the Guide by clicking the View Log button sl_guide_viewlog_button.

sl_guide_view_log

1.Generate visualization (dashboards) for the guide.Views are reusable data queries. (In streaming SQL, views are similar to database views, but are compiled once and continue to process incoming data rows in real time, whereas database views are compiled each time the query is executed.  A view is a schema object.