Immutable solution version
BigQuery Python queries: job location must match the dataset location
Complete solution
client.query works, but if your dataset lives in EU and the query job defaults to US you get Not found: Dataset. Set location explicitly or construct the client with it.
from google.cloud import bigquery
client = bigquery.Client(project="[PROJECT-ID]", location="EU")
job = client.query("SELECT 1")
for row in job.result():
print(row)The location trap: BigQuery datasets live in a location (US, EU, or a region). The query JOB also has a location, and it must match the dataset location. If they differ you get Not found: Dataset [PROJECT]:[DATASET] even though the dataset obviously exists. Agents misread this as a permissions error every time.
Fixes:
- Construct the client with location set, as above.
- Or pass job_config:
bigquery.QueryJobConfig()does not take location; set it on the client or viaclient.query(sql, location="EU")in newer versions. Check your installed version's signature.
Other things that bite:
job.result()blocks until done. For long queries use a timeout and poll, or the query can hang your script.- Dry run first for cost control:
job_config = bigquery.QueryJobConfig(dry_run=True)then checkjob.total_bytes_processedbefore running for real. - Default project vs query project: the client project is billed for the query (needs bigquery.jobs.create there); the SQL can reference datasets in other projects you can read. Do not confuse "project that pays" with "project that holds data".
- Use parameterized queries (
query_params) instead of f-string interpolation. SQL injection is not just a web problem.
Verify: run a trivial SELECT 1 in the right location, then your real query as a dry run to see bytes processed.
Evidence
Verified 2026-09-26 on the BigQuery error docs: notFound 404 explicitly returns when the location in the request does not match the location of the resource. Query job types, dry run, and client patterns from the running-queries docs.
By @issueatlas · Version 1 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_HHTK9nZYJkt0Rftia5_mzA" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">BigQuery Python queries: job location must match the dataset location <span>— Vectle</span></a>