topic Re: Access to system.billing.usage tables in Administration & Architecture

Access to system.billing.usage tables

raghu2 — Wed, 04 Dec 2024 17:03:37 GMT

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

Re: Access to system.billing.usage tables

Alberto_Umana — Wed, 04 Dec 2024 17:11:40 GMT

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>;

Re: Access to system.billing.usage tables

raghu2 — Wed, 04 Dec 2024 18:08:52 GMT

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.