Standalone Data Lake

Provisioning Standalone Data Lake:

Access a Standalone Data Lake in SAP HANA Cloud

Load Data into Standalone Data Lake in SAP HANA Cloud

 /*==============================================================*/
 /* User: ACLOUDGURUJIDL                                                   */
 /*==============================================================*/
 CREATE USER ACLOUDGURUJIDL IDENTIFIED BY "Your Password";

 /*==============================================================*/
 /* Table: STUDENTS                                              */
 /*==============================================================*/
 create table ACLOUDGURUJI.STUDENTS (
   S_ID					varchar(3),
   S_NAME               varchar(30),
   S_DEPT	            varchar(40),
   constraint PK_STUDENTS primary key (S_ID)
 );

Now upload a source AWS S3 file:

Sample File:

27B

StudentsSS3.tbl

Open

truncate table ACLOUDGURUJI.STUDENTS;
commit;

load table ACLOUDGURUJI.STUDENTS (
   S_ID,
   S_NAME,
   S_DEPT       
)
from 's3://acloudgurujis3/hana-files/StudentsSS3.tbl'
ACCESS_KEY_ID 'Your AWS ACCESS_KEY_ID'
SECRET_ACCESS_KEY 'Your AWS SECRET_ACCESS_KEY' 
REGION 'us-east-1'
quotes off
escapes off
format ascii
delimited by '|'
row delimited by '\n';
commit;
rollback;

Data Got inserted in HANA Cloud Data Lake Relational Table:

You can also use any other DML to work with DL:

INSERT INTO ACLOUDGURUJI.STUDENTS (S_ID, S_NAME, S_DEPT)
VALUES ('S01', 'John Doe', 'Computer Science');
 
select * from ACLOUDGURUJI.STUDENTS;

Complete DDL and DML:

/*==============================================================*/
 /* User: ACLOUDGURUJIDL                                         */
 /*==============================================================*/
 CREATE USER ACLOUDGURUJIDL IDENTIFIED BY "Your Password";

 /*==============================================================*/
 /* Table: STUDENTS                                              */
 /*==============================================================*/
 create table ACLOUDGURUJI.STUDENTS (
   S_ID					varchar(3),
   S_NAME               varchar(30),
   S_DEPT	            varchar(40),
   constraint PK_STUDENTS primary key (S_ID)
 );


truncate table ACLOUDGURUJI.STUDENTS;
commit;

load table ACLOUDGURUJI.STUDENTS (
   S_ID,
   S_NAME,
   S_DEPT       
)
from 's3://acloudgurujis3/hana-files/StudentsSS3.tbl'
ACCESS_KEY_ID 'Your AWS ACCESS_KEY_ID'
SECRET_ACCESS_KEY 'Your AWS SECRET_ACCESS_KEY' 
REGION 'us-east-1'
quotes off
escapes off
format ascii
delimited by '|'
row delimited by '\n';
commit;
rollback;

INSERT INTO ACLOUDGURUJI.STUDENTS (S_ID, S_NAME, S_DEPT)
VALUES ('S01', 'John Doe', 'Computer Science');

select * from ACLOUDGURUJI.STUDENTS;

More Read:

SAP Help Portal | SAP Online Helphelp.sap.com