This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

USING BigQuery and having this error

Posted on 02-22-2025 08:03 AM
hajira_fatima
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

"Not found: Table hajira-450716:avocado_data.avocado_prices was not found in location US" having this error while using bigquery ,tried everything ,suggest some solutions thank you

0 4 86
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
mars124
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

From which interface are you running this query?

0 Likes

Posted on --/--/---- --:-- AM
mdideles
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

See if there's a typo on the name.

Then, see if you are joining this table/view to another and if they are on different regions.  I suspect the  other table/view where you join this table/view is on "US" but this one is not.

0 Likes

Posted on --/--/---- --:-- AM
hajira_fatima
Bronze 1
Bronze 1
In response to mdideles
Reply posted on --/--/---- --:-- AM

Thank you,
checked for typos ,there are none and both tables are under US region

0 Likes

Posted on --/--/---- --:-- AM
singhgyan
Staff
Reply posted on --/--/---- --:-- AM

Is it possible to share query which is giving this error?

0 Likes