---
parser: v2
auto_validation: true
primary_tag: products>sap-hana-streaming-analytics
tags: [ tutorial>beginner, products>sap-hana-streaming-analytics, products>sap-hana-studio ]
author_name: Bill Jiang
author_profile: https://github.com/BillJiangSAP
time: 20
slug: sds-part2-create-streaming-project
canonical_url: https://developers.sap.com/tutorials/sds-part2-create-streaming-project
---
 
# Create a Streaming Project in SAP HANA Smart Data Streaming
<!-- description --> Part 2 of 9. Create a SAP HANA Smart Data Streaming (SDS) project in SAP HANA Studio with streaming plug-in and visual editor.

## Prerequisites  
 - **Tutorials:** [Configure SAP HANA Smart Data Streaming Server Connection](https://developers.sap.com/tutorials/sds-part1-configure-streaming-server.html)

## You will learn  
 - Creating a new streaming project: a project contains one or more input streams/windows and then directs the flow of data through continuous queries and/or custom operators, publishing output events via adapters.
 - Defining an input stream to receive incoming events: All incoming events enter a project via an input stream or input window. The schema of the input stream (or window) defines the fields that events on that stream will (or may) contain.


---

### Create a New Streaming Project
    

1. Click the **File** menu. You can also press **Alt+f**. Then click the **New** > **Project...**. You can also press **r**.

    ![Create a new Project](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-a-new-project/1-create-a-new-project.png)

2. Click **New Streaming Project**, then click **Next**.

    ![Select Streaming Project](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-a-new-project/2-select-streaming-project.png)

3. Enter `freezer_monitoring` in the **Name** box (be sure and only use lower case) and accept the default **Directory** location.

    ![Provide name and location](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-a-new-project/3-provide-name-and-location.png)

4. Click **Finish**. You can also press **Alt+f**.

    ![Click Finish](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-a-new-project/4-click-finish.png)


### Create the Required SAP HANA Tables
    

1. Go to **SAP HANA Administration Console** perspective, then **Systems** view. Right click the system you are working with.

    ![open file](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-tables/1-select-system.png)

2. Select **Open SQL Console** menu item to open a console that will automatically connect to your system.

    ![open file](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-tables/2-open-sql-console.png)

3. Select the newly created SQL console tab. The tab window will have the title in the format of **`<Your System Name> - SQL Console <Window Number>`**

    ![open file](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-tables/3-sql-console.png)

4. Copy the code below into the SQL window.

   ```sql
   --These are the SQL commands to set up the back-end tables for the Freezer Monitoring hands-on exercise.

   CREATE COLUMN TABLE "SYSTEM"."ACTIVITY_HIST"
   (	"MACHINEID"			VARCHAR(15),
   	"EVENT_TIME"		TIMESTAMP,
   	"EVENT_NAME"		VARCHAR(20),
   	"EVENT_DESCRIPTION"	VARCHAR(30),
   	"EVENT_VALUE"		VARCHAR(30)
   );

   CREATE COLUMN TABLE "SYSTEM"."DASHBOARD"
   (	"MACHINEID" 	VARCHAR(15) NOT NULL ,
   	"POWER_STATUS" VARCHAR(30),
   	"CURR_TEMP" 	DECIMAL(4,2),
   	PRIMARY KEY ("MACHINEID")
    );

   CREATE COLUMN TABLE "SYSTEM"."MACHINE_REF"
   (	"MACHINEID" 	VARCHAR(15) NOT NULL ,
   	 "MACHINETYPE" 	VARCHAR(15),
   	 "MAX_TEMP" 	DECIMAL(4,2),
   	 "MIN_TEMP" 	DECIMAL(4,2),
   	 "LOCATION" 	VARCHAR(25),
   	 "TEMP_UNIT" 	VARCHAR(2),
   	 PRIMARY KEY ("MACHINEID")
   );

   CREATE COLUMN TABLE "SYSTEM"."POWER_OUTAGES"
   (	"MACHINEID" 		VARCHAR(15),
   	"POWER_OFF_TIME" 	LONGDATE,
   	"POWER_ON_TIME" 	LONGDATE,
   	"DURATION_MIN" 	DOUBLE CS_DOUBLE
   );

   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( '2DDDBW3TP','VEND',50,35,'WALG31','F');
   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( 'EKM49RTXK','COOL',50,35,'FRI7','F');
   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( 'RB82KMY3S','VEND',50,35,'JRB235','F');
   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( '4CBH7792RN','COOL',50,35,'WALG33','F');
   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( 'JMD51RTKK','VEND',10,2,'BP762','C');
   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( 'GGR23RTXK','FREEZE',32,0,'HIN88','F');
   INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
   ( '8HRT4WX2','VEND',50,35,'ORD311','F');

   ```

5. Execute the SQL script by pressing the **Execute** button.

    ![execute query](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-tables/5-execute-sql-query.png)

6. Confirm that they executed correctly. You should have these tables.

    ![check tables](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-tables/6-check-tables.png)

7. Check to see that all tables created are empty except for **`MACHINE_REF`** which will have 7 rows of data.

    ![check content](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/create-tables/7-check-content.png)



### Create an Input Stream
    

1. When you created the project, it created an input stream called "NEWSTREAM" by default.

    ![add a stream](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/1-add-a-stream.png)

2. Click the icon to the left of the name **NEWSTREAM** and change the name of this stream to **MACHINEDATA**, then press **Enter** key.

    ![rename a stream](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/2-rename-a-stream.png)

3. Click on the **+** to the left of Schema to expand it.

    ![show schema](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/3-show-schema.png)

4. Now hover the cursor over the right edge of the **MACHINEDATA** shape so that the toolbar appears. Click on the **Add Column** tool.

    ![add column](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/4-add-column.png)

5. Repeat step 5 three more times, so there are a total of 5 columns.

    ![add 5 columns](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/5-add-5-columns.png)

6. Double click on the name **`Column1`** and change the name of this column to **MACHINEID**.

    ![rename column](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/6-rename-column.png)

7. Double click on **(INTEGER)** to the right of **MACHINEID** to change the datatype for this column to string. (after double clicking, click the drop down arrow, and select **string**)

    ![select column type](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/7-select-column-type.png)

8. Change the rest of the column names and data types as shown:

    ![all columns](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/8-all-columns.png)

9. Click here **-**  to collapse the shape.

    ![minimize](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/9-minimize.png)

    Note: You can just drag the shape to a new position to organize our diagram.

    ![drag stream](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/sds-part2-create-streaming-project/new-stream/10-drag-stream.png)