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?
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!