What is happening?
The BigQuery connector has stopped syncing because it hit a daily spending limit (hard cap) set in your Google Cloud project. No further data can be processed until the quota is increased or resets at midnight.
Error: BigQuery exceeded the daily custom quota for maximum query TiB processed in Google Cloud project, which is set by the project administrator. For more information see https://cloud.google.com/bigquery/cost-controls. To update the limit, go to https://cloud.google.com/bigquery/redirects/increase-query-cost-quota.
Why did this happen?
This error typically occurs when a Google Cloud administrator has enforced a limit on the amount of data (in Tebibytes) BigQuery can process each day to control costs. Common causes include:
Large Data Syncs: Running multiple high-volume reports or historical backfills in a single day.
Low Quota Limit: The "Query usage per day" limit is set too low for your current reporting needs.
Shared Project Usage: Other users or applications in the same Google Cloud project have consumed the aggregate daily quota.
Follow these steps to resolve the issue:
Important: These steps require the Owner, Editor, or Quota Administrator role in your Google Cloud project.
Navigate to External Platform: Open the Google Cloud Console Quotas page.
Locate the Source: Use the Service filter to search for BigQuery API.
See image for how it looks in platform.Action: * Find the metric Query usage per day (or
QueryUsagePerDay).Select the checkbox next to it and click Edit Quotas.
Enter a higher value in the New limit field (measured in TiB).
External Steps: Click Submit Request. Most custom quota increases are applied instantly, but large increases may require a brief automated approval.
Verify: Return to Alvie and trigger a manual rerun of the connector. It should now transition to Healthy (Green).
Prevention & Tips To avoid seeing this error again:
Monitor Usage Alerts: Set up Cloud Billing Budgets to receive email alerts when you reach 50%, 75%, or 90% of your expected spend.
Query Optimization: Ensure your BigQuery tables are partitioned or clustered to reduce the number of bytes scanned per query.
Daily Reset: Note that these quotas reset daily at midnight Pacific Time (PT).
If you encounter any further issues or need additional assistance, please don't hesitate to reach out to the Alvie support team.