BigQuery console api "Cannot start a job without a project id"

Question

I can call a sql on big query browser tool and I installed the bq tool on centos and register it now I can able connect bigdata and show the dataset or get the table data with head method but when i call the quert from bq tool I got "BigQuery error in query operation: Cannot start a job without a project id." I searched it on google but nothing found helpful.

Does anyone run a select query via "This is BigQuery CLI v2.0.1"

BigQuery> ls

   projectId     friendlyName  
 -------------- -------------- 
  XXXX

API Project

BigQuery> show publicdata:samples.shakespeare   
Table publicdata:samples.shakespeare


   Last modified                  Schema                 Total Rows   Total Bytes   Expiration  
 ----------------- ------------------------------------ ------------ ------------- ------------ 
  02 May 02:47:25   |- word: string (required)           164656       6432064                   
                    |- word_count: integer (required)                                           
                    |- corpus: string (required)                                                
                    |- corpus_date: integer (required)

BigQuery> query "SELECT  title FROM [publicdata:samples.wikipedia] LIMIT 10 "
BigQuery error in query operation: Cannot start a job without a project id.

Victor Mota · Accepted Answer · 2016-11-10 03:04:39Z

3

In order to run a query, you need to provide a project id, which is the project that gets billed for the query (there is a free quota of 25GB/month, but we still need a project to attribute the usage to). You can specify a project either with the --project_id flag or by setting a default project by running gcloud config set project PROJECT_ID. See the docs for bq and especially the 'Working with projects' section here.

Also it sounds like you may have an old version of bq. The most recent can be downloaded here: https://cloud.google.com/sdk/docs/

edited Nov 10, 2016 at 3:04

Victor Mota

1,26912 silver badges17 bronze badges

answered Dec 18, 2012 at 2:13

Jordan Tigani

26.7k5 gold badges63 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

BigQuery console api "Cannot start a job without a project id"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related