0

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?

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.