Access space table using Open SQL User in SAP Data Wherehouse Cloud - DWC

[diego_oliveira4]

In my SAP Datawherehouse Cloud environment, I created a database user in space and enabled the Open SQL Schema functionality.

However, I cannot access the tables (remote and local) that are created in Space Schema.

Is there any way for the Open SQL Schema user to access the space tables directly?

[jascha_meiswinkel · Accepted solution]

Hi Diego,

you have to expose the tables or views for consumption, see https://help.sap.com/viewer/c8a54ee704e94e15926551293243fd1d/cloud/en-US/40ec77ec24f244279a81448969a....

Thanks,
Jascha

[amoghkulkarni]

Hello Diego,

As mentioned by Jascha, you can expose individual views for consumption directly from your Modeling screen by following the steps in the documentation. DWC doesn't allow you to directly expose Tables (Local or Remote) for external consumption but only Views modelled in DWC.

A workaround for your case would be to create a wrapper view for your Tables i.e., a view based on your table without any transformations and exposing this view for external consumption.

If your question is answered, please mark a best answer and close the thread.

Regards,

Amogh K