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