Not able to see all rows from system.information_schema tables

Assign BROWSE privileges on objects to view data in information_schema.

Written by parth.sundarka

Last published at: July 22nd, 2025

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 (AWSAzureGCP) 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.