Access to system.billing.usage tables

raghu2
Databricks Partner

I have Account, Marketplace, Billing Admin roles. I have visibility to system.billing.list_prices table only.

How do I get access to system.billing.usage tables? Databricks instance is on AWS.

Thanks

Alberto_Umana
Databricks Employee
Databricks Employee

Hello @raghu2,

Are you getting any error when querying table: system.billing.usage?

Are you able to browse to the table through the catalog?

You would likely need the below permissions:

GRANT USE ON SCHEMA system.billing TO <user>;
GRANT SELECT ON TABLE system.billing.usage TO <user>;

raghu2
Databricks Partner

Hi @Alberto_Umana, Thanks for your response. I needed Metastore Admin permissions too. In account console, I changed the Metastore Admin to be a group, became a part of the group. With this other tables were visible. With this permission using the grant commands you provided, I can grant permissions to other users.