Tutorial 2A: Creating a Stream and VIEW in SQLstream s-Studio

<< Click to Display Table of Contents >>

Navigation:  Building Streaming Applications > Tutorial 2: Introduction to Coding with Streaming SQL >

Tutorial 2A: Creating a Stream and VIEW in SQLstream s-Studio

Previous pageReturn to chapter overviewNext page

In this tutorial, we will use s-Studio, SQLstream's Integrated Development Environment, to create a stream and view. s-Studio helps you write SQL to run in s-Server. It also provides an environment where you can see all objects in s-Server. Most objects--streams, tables, functions, views, and pumps--appear under schemas. You can inspect these objects by clicking them. You can create new objects by right-clicking the object's folder as well as work with the SQL for each object.

Development Pane Contents after First SQLstream Server Connection

 

This guide walks you through the following tasks:

1.Connecting to s-Server in s-Studio
2.Creating a server object and foreign stream to connect with a log file (this is the same data we worked with in StreamLab)
3.Creating a VIEW on the foreign stream that performs a basic calculation
4.Querying the VIEW
5.Using s-Dashboard to show streaming data in dashboard