Managed Data Lake

Free Tier Managed DL (no difference :P):

Remote Source in DB Explorer:

Terminology in Data Lake Relational Engine (SAP HANA DB-Managed):

SAP Help Portal | SAP Online Helphelp.sap.com

Real-World Scenario:

Push HANA Cloud Data into HANA Data Lake

-- Create HANA table
CREATE TABLE STUDENTS (
        "S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30)
);

-- load in some dummy data
insert into STUDENTS values ( 'S01', 'Partha', 'SAP' );
insert into STUDENTS values ( 'S02', 'John', 'Microsoft' );
insert into STUDENTS values ( 'S03', 'Mili', 'AWS' );

-- create the HDL table
call "SYSRDL#CG".REMOTE_EXECUTE('
drop table if exists STUDENTS;
CREATE TABLE STUDENTS (
        "S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30) );
');

-- creates the HANA SDA table for the table created above
-- HDL uses SYSRDL#CG for every remote database
-- HDL uses SYSRDL#CG_SOURCE for every remote server
-- "<NULL>" is just a dummy placeholder as IQ/HDL ignore this parameter anyway

CREATE VIRTUAL TABLE VT_HDL_STUDENTS AT "SYSRDL#CG_SOURCE"."<NULL>"."SYSRDL#CG"."STUDENTS";

-- get counts and make sure virtual table works
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;

-- copy data
insert into VT_HDL_STUDENTS select * from STUDENTS;

-- Get final counts to see that they are the same
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;

Complete Script:

-- create HANA table
CREATE TABLE STUDENTS (
        "S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30)
);


-- load in some dummy data
insert into STUDENTS values ( 'S01', 'Partha', 'SAP' );
insert into STUDENTS values ( 'S02', 'John', 'Microsoft' );
insert into STUDENTS values ( 'S03', 'Mili', 'AWS' );


-- create the HDL table
call "SYSRDL#CG".REMOTE_EXECUTE('
drop table if exists STUDENTS;
CREATE TABLE STUDENTS (
        "S_ID" VARCHAR(3), "S_NAME" VARCHAR(20), "S_DEPT" VARCHAR(30) );
');



-- creates the HANA SDA table for the table created above
-- HDL uses SYSRDL#CG for every remote database
-- HDL uses SYSRDL#CG_SOURCE for every remote server
-- "<NULL>" is just a dummy placeholder as IQ/HDL ignore this parameter anyway

CREATE VIRTUAL TABLE VT_HDL_STUDENTS AT "SYSRDL#CG_SOURCE"."<NULL>"."SYSRDL#CG"."STUDENTS";


-- get counts and make sure virtual table works
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;


-- copy data
insert into VT_HDL_STUDENTS select * from STUDENTS;


-- get final counts to see that they are the same
select 'HANA cnt: ' || count(*) from STUDENTS;
select 'HDL Virtual Table cnt: ' || count(*) from VT_HDL_STUDENTS;