3416424 - How to check consumption of embedded Data Lake of SAP Datasphere

Using embedded Data Lake in a SAP Datasphere as per Blog Post Working with the Embedded Data Lake in SAP Datasphere,
how to check the consumed data volume using REMOTE_EXECUTE Procedure for SAP HANA Database?

SAP Datasphere with Data Lake Storage.

Using sp_iqtablesize, check the code snippet below as an example.
It creates a view with the required information: 

CALL "DWC_GLOBAL"."DATA_LAKE_EXECUTE"(

                                'create or replace view tab_size as

                        select OwnerName, TableName, KBytes

                        from sys.systab t key join sys.sysuser u, dbo.sp_iqtablesize(string(u.user_name, ''.'', t.table_name)) where u.user_name = CURRENT_USER and t.table_type = 1'

                );

                CALL "DWC_GLOBAL"."DATA_LAKE_CREATE_VIRTUAL_TABLE"(

                                                VIRTUAL_TABLE_NAME => 'tab_size',

                                                DATA_LAKE_TABLE_NAME => 'tab_size'

                );

                SELECT * FROM "tab_size";

• Configure the Size of Your SAP Datasphere Tenant
• Working with the Embedded Data Lake in SAP Datasphere
• sp_iqtablesize Procedure for Data Lake Relational Engine

KBA , HAN-DB-ENG , SAP HANA DB Engines , DS-SM , Space Management , How To