Error with BQ command line tool: Cannot start a job without a project id

Question

I am having issues with the BQ-Command line tool. Specifically when trying to query a dataset/table, whether one the public datasets or my own I get the error:

BigQuery error in query operation: Cannot start a job without a project id.

I have a project id set as default as per the attached screen shot. Any help you could give would be appreciated. :-)

Thanks

BigQuery> ls projectId friendlyName
de********nts          De********ing  
BigQuery> query 'select count(*) from publicdata:samples.shakespeare' BigQuery error in query operation: Cannot start a job without a project id. BigQuery> show publicdata:samples.shakespeare Table publicdata:samples.shakespeare

Last modified Schema Total Rows Total Bytes Expiration

22 Oct 07:27:07 |- word: string (required) 164656 6432064
|- word_count: integer (required)
|- corpus: string (required)
|- corpus_date: integer (required)

Max Ostapenko · Accepted Answer · 2015-03-05 22:47:34Z

0

You should configure gcloud command-line tool first:

gcloud config set project 'yourProjectId'

This project is billed for querying not public data.

Then you can run your query:

bq query 'select count(*) from publicdata:samples.shakespeare'

answered Mar 5, 2015 at 22:47

Max Ostapenko

5465 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alexey Maloletkin Over a year ago

you can also can try bq --project=<you_project> query "select count(*) from [publicdata:samples.shakespeare]"

Collectives™ on Stack Overflow

Error with BQ command line tool: Cannot start a job without a project id

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related