Using the API, get the list of the schemas and tables a group or user has permissions for

[robmcclain]

I am attempting to use the Databricks API to get a list of the schemas and tables a group or user has permissions for.  Is this possible?  Is there another method I should be using instead?

I see the Unity Catalog > Grants > Get permissions endpoint can list the principals that have permissions for a schema or table, but this is the inverse of what I need.

[Walter_C · Accepted solution]

To make sure I am in the correct path, you want to provide a group id for example or an user id and that the API retrieves all the objects that this user has access to? If this is the case unfortunately as of now there is no API available to collect this information as the permissions are handled by object and not by the principal

[robmcclain]

Thanks, @Walter_C.  In my case, I was able to get the data I needed by using the Databricks SQL Driver for Node.js , querying the information_schema.table_privileges table.