This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Query usage per day per user by information schema

Posted on 02-05-2025 09:05 AM
actmarcos
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi,

I have about 20 project_ids and each one has different value for Query usage per day per user.
I'm trying to get this information at information schema but I didn't find.

Is there a way get the value set in Query usage per day per user at information_schema?

Tks!

0 1 137
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
nikacalupas
Staff
Reply posted on --/--/---- --:-- AM

Hi actmarcos,

Welcome to the Google Cloud Community!

The "Query usage per day per user" limit in BigQuery is not accessible through INFORMATION_SCHEMA. You need to use the BigQuery API or Google Cloud SDK (gcloud) to retrieve project configuration information. The exact limit may not be a direct field, but you can infer it by examining related quota settings. Use projects.get() from the API. Also consider using Cloud Monitoring API to track usage. Remember to handle API calls responsibly with respect to rate limits and appropriate permissions.

For more information, you may refer to this documentation for more insights. 

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.