Setting Query Location in GCP BigQuery SQL Script

[mohamedsithik]

Hello Everyone,

Greetings!

I need assistance with setting the query location in my SQL script for GCP BigQuery.

My GCP BigQuery dataset, project, and GCS bucket are all located in the me-central2 region (Saudi Arabia, Dammam). I also have SQL queries saved in the me-central2 region. However, when running the script, GCP BigQuery throws an error indicating that it cannot find the dataset or table in the US location. This suggests that the script is executing in the US region by default.

To resolve this, I currently have to manually go to the settings, select the advanced options, and set the region to me-central2. How can I specify the me-central2 region permanently in the script to avoid this issue?

Thank you for your support.  

Mdsithik