I am trying to use BigQuery and want to search from the Google Cloud SDK Shell.
I logged in and set up with gcloud config init successfully.
I used the BigQuery console to put data in my dataset table.
When I run the following query in the console it runs successfully:
select count(*) from `quick-signal-480404-q9.test.ddd`
But when I run it in the terminal it errors:
bq query 'select count(*) from `quick-signal-480404-q9.test.ddd`'
Error returned:
<STRING_LITERAL> "\'select count(*) from `quick_signal_480404-q9.test.ddd`\'
"" at line 1, column 1.
Was expecting: <EOF>
I also tried:
bq query 'select count(*) from `quick-signal-480404-q9.test.ddd`;'
and
bq query "select count(*) from `quick-signal-480404-q9.test.ddd`;"
I also tried using regular quotes around the table name, and ' around the select statement, as well as [] around each part of the tables.
All received the same error above.
Is there something obvious I am missing?