Google Certified Professional Data Engineer

Sign Up Free or Log In to participate!

Unexpected string error in Big Query

Hi All,

I am trying to write a simple select query in big query like below in the format project name. dataset name. table name)

SELECT * FROM ‘local-storm-291820.arvindlab1.products’ 

This gives me an error like so

Syntax error: Unexpected string literal ‘local-storm-291820.arvindlab1.products’ at [1:15]

I am quite sure this is something silly on my side. Could someone please clarify where the mistake in the query is?



1 Answers

Hi Arvind,

It looks like the table name is inside single quotes, so BigQuery thinks it’s a string. The table name should be enclosed in backticks instead.


Hope this helps!

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?