👀 Views: 19 💬 Answers: 1 📅 Created: 2025-06-12

bigquery gcp scheduled-queries SQL

I'm working through a tutorial and I've searched everywhere and can't find a clear answer. I'm working on a personal project and I'm running into an scenario with a scheduled query in BigQuery that returns a 'Table/View Not Found' behavior, even though the table definitely exists. The query is supposed to run every day at 3 AM, and I've confirmed that the table is available in the dataset. Here's the SQL I am using: ```sql SELECT * FROM `my_project.my_dataset.my_table` WHERE event_date = CURRENT_DATE() ``` I initially created the scheduled query through the BigQuery UI and double-checked the dataset permissions. The service account used for the scheduled query has the necessary roles assigned, including BigQuery Data Viewer for both the project and the dataset. However, I still get the behavior on execution: ``` behavior: Table 'my_project.my_dataset.my_table' not found ``` To troubleshoot, I tried running the same SQL query directly in the BigQuery console, and it works perfectly fine. I also verified that I am using the correct project ID and that the table name is spelled correctly, including case sensitivity. Does anyone have insights on why the scheduled query might not be able to find the table? Additionally, I checked the region settings for the dataset and the scheduled query, and they are both set to `us-central1`, so that shouldn't be the scenario. I've also looked into the logs for the scheduled query but couldn't find anything that points to a configuration behavior. Any suggestions on how to resolve this would be greatly appreciated! I'm working in a macOS environment. What's the best practice here?