GCP Cloud Functions Timeout When Accessing BigQuery with Python Client Library
I'm integrating two systems and After trying multiple solutions online, I still can't figure this out. I'm working with a timeout scenario with my Google Cloud Function that attempts to query data from BigQuery using the Python client library. I've set the function timeout to the maximum of 540 seconds, but I'm still getting the behavior `Function execution took too long`. Here’s a snippet of the code I’m using: ```python from google.cloud import bigquery def query_bigquery(request): client = bigquery.Client() query = 'SELECT * FROM `my_project.my_dataset.my_table` LIMIT 1000' query_job = client.query(query) results = query_job.result() # Wait for the job to complete. return results.to_dataframe().to_json() ``` I have tested the query directly in the BigQuery console, and it runs efficiently there. I also tried increasing the number of rows returned, but that didn't help. The function is triggered via an HTTP request and seems to hit the timeout even when querying a small dataset. To troubleshoot, I added logging at various checkpoints, yet the function appears to hang at `query_job.result()`. I have ensured that the necessary IAM roles are assigned for the service account linked to the Cloud Function. Are there any specific configurations or best practices to follow when connecting to BigQuery from Cloud Functions that could mitigate this timeout scenario? Any help would be appreciated! Any advice would be much appreciated. This is happening in both development and production on Windows 11.