StreamLab Guides Overview
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 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.
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.
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 .
Viewing the Log
You can view the SQL generated by the Guide by clicking the View Log button .
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.