BigQuery error in load operation: Not found: Project during bq load

Problem ?

While loading files into Bigquery from the bq command line utility, you will have to set the default project or the bq load will throw the below error

bq load --source_format=NEWLINE_DELIMITED_JSON <project-id>:<my-dataset.table>\ngs://<project-id>.appspot.com/nt.ndjson

BigQuery error in load operation: Not found: Project <project-friendly-name>

Solution ?

Method #1 Set default project

Set the default working project before you execute the bq load command

\n
• gcloud config set project <project-id>

Method #2 Pass the project-id via an argument

Embed and pass the project id in the bq command like shown below

\n
• bq load --project_id=<project-id> ...

Example:

bq load --project_id=<project-id> --source_format=NEWLINE_DELIMITED_JSON \n<my-dataset.newtable> gs://<project-id>.appspot.com/nt.ndjson\n

mCollins

posted on