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?

Regards

Arvind

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.

See: https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical

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?