Problem
You are not able to see all rows from system.information_schema
tables even though you have SELECT
permission on the table.
Cause
You can only see the rows from the catalogs you have access to.
For example, if there are ten catalogs in your workspace, but you have access to only four of the ten, then you can view data related to the four catalogs in information_schema
.
Refer to the TABLES (AWS | Azure | GCP) documentation for details.
Solution
Ask your metastore admin or the securable object owner to assign BROWSE
permission on the UC object to you, so you can view related information in the information_schema
table.
If you need to query data across all catalogs or schemas, instead of assigning BROWSE
permissions on each UC object, ask your metastore admin to assign METASTORE_ADMIN
privileges.