First, you need to execute a SQL statement on HANA to create a database schema where you will store your event data. In the database schema, you will also create some tables that you will use later in this tutorial.
Go to the SAP HANA Administration Console perspective, then the Systems view.
Right-click on the tenant database that you are working with, and select Open SQL Console to open a console that automatically connects to your system.
Note: If you are following the HANA Express tutorial series to this point, the tenant database is called HXE by default. Don’t select the System database.
Copy the code below and paste it into the newly created SQL console tab.
```SQL
CREATE SCHEMA STREAMING;
CREATE COLUMN TABLE "STREAMING"."DASHBOARD"
( "MACHINEID" VARCHAR(15) NOT NULL ,
"POWER_STATUS" VARCHAR(30),
"CURR_TEMP" DECIMAL(4,2),
PRIMARY KEY ("MACHINEID")
);
CREATE COLUMN TABLE "STREAMING"."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 "STREAMING"."POWER_OUTAGES"
( "MACHINEID" VARCHAR(15),
"POWER_OFF_TIME" LONGDATE,
"POWER_ON_TIME" LONGDATE,
"DURATION_MIN" DOUBLE CS_DOUBLE
);
CREATE COLUMN TABLE "STREAMING"."ACTIVITY_HIST"
( "MACHINEID" VARCHAR(15),
"EVENT_TIME" LONGDATE CS_LONGDATE,
"EVENT_NAME" VARCHAR(15),
"EVENT_DESCRIPTION" VARCHAR(100),
"EVENT_VALUE" VARCHAR(25)
);
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '2B','VEND',50,35,'WALG31','F');
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '1A','COOL',50,35,'FRI7','F');
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '4D','VEND',50,35,'JRB235','F');
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '5E','COOL',50,35,'WALG33','F');
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '3C','VEND',10,2,'BP762','C');
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '6F','FREEZE',32,0,'HIN88','F');
INSERT INTO "STREAMING"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '7G','VEND',50,35,'ORD311','F');
```
Execute the SQL script by pressing the Execute button (in the toolbar of the SQL console).
Check the HANA database catalog in the SAP HANA Administration Console to confirm that the schema has been created and contains the following tables:
DASHBOARD
MACHINE_REF
POWER_OUTAGES
ACTIVITY_HIST
The table MACHINE_REF
should have 7 rows of data.