BigQuery Error while trying to query data?

Question

I am trying to run simple query on Google Bigquery. But each time when I run the query SELECT COUNT(totals.visits) FROM 122443995.ga_sessions_20160817 I get following error

Encountered " "FROM" "FROM "" at line 1, column 29. Was expecting: <EOF>

What could be the possible error in the query syntax?

Elliott Brossard · Accepted Answer · 2016-08-19 03:50:21Z

4

You probably need to escape the table name. With legacy SQL, you would use square brackets, e.g.:

SELECT COUNT(totals.visits) FROM [122443995.ga_sessions_20160817];

With standard SQL, you would use backticks, e.g.:

SELECT COUNT(totals.visits) FROM `122443995.ga_sessions_20160817`;

answered Aug 19, 2016 at 3:50

Elliott Brossard

34k2 gold badges75 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Embedded_Mugs · Accepted Answer · 2018-02-02 20:53:02Z

1

For me, using parentheses to surround the clause in FROM solved it for me. So instead of

SELECT totals FROM t1

use

SELECT totals FROM (t1)

answered Feb 2, 2018 at 20:53

Embedded_Mugs

2,4823 gold badges31 silver badges42 bronze badges

Collectives™ on Stack Overflow

BigQuery Error while trying to query data?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related