Project exceeds quota getting BigQuery data using API
Stay organized with collections
Save and categorize content based on your preferences.
Problem
When using BigQuery REST API you get the following message: Exceeded rate limits: Your project:123456 exceeded quota for tabledata.list bytes per second per project.
Environment
Solution
- Use the BigQuery Storage API, which is designed to be an improved alternative to the record-based paginated access used by tabledata.list, it should provide a significant performance boost over the tabledata.list API and it is not subject to quota limitations on bytes per second. However, if it is not feasible, users would need to implement a retry strategy for tabledata.list requests.
Cause
The users are using
tabledata.list API method which has the per-minute limit on the bytes read (currently of 3.6 GB). This limit cannot be adjusted.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-10 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-10 UTC."],[],[]]
