SAP Knowledge Base Article - Public

3469023 - Unable to access SAP datasphere Local table in the database explorer for viewing data


When trying to consume the local tables present in the space in the Database explorer, unable to see the tables name being fetched in the repository.


SAP Datasphere

Reproducing the Issue

    • Local table is accessible in Data Builder
    • When accessing the Space management >Database users >SPACE USER > Open Database Explorer
    • Selecting the correct Schema, table is not found in the repository


    • There is a difference between a Database Analysis user and space user.
    • The database user in the space is not supposed to access the local table in space schema, but only allow the database user to connect external tools to the space schema and read views that are exposed for consumption.
      So for the local table in space schema, if you want to access it via database user, you need to create a view based on the local table, and then expose the view for consumption, then you can read the view.

    See Also

    • User Management
    • 3469992 - Database user on Space-level is not able to consume tables and all schemas in SAP Datasphere


    database explorer, database analysis user, database user, table, data builder, not found, db user, db analysis user, local table , KBA , DS-SM , Space Management , Problem


    SAP Datasphere 1.0