Accessing csv uploading error collection on Big Query

0
votes

I'm a super beginner with big query.

So, I've managed to store a csv into Google Data Storage, created a table, it returned some erros and I would like to check those errors.

I've seen in some resources about that, such as:

https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv

BigQuery - Where can I find the error stream?

I understood I should run this command in the terminal: bq --format=prettyjson show -j <JobID>

However, when I run that in my root terminal I get this: -bash: bq: command not found

When I run that in the big query terminal in https://console.cloud.google.com/bigquery I get: Syntax error: Unexpected identifier "bq" at [1:1]

enter image description here

What am I missing?

1
google-bigquery

1 Answers

1
votes

It seems that you're missing bq binary installed in your visitor machine, this error: bq: command not found reflects my presumption.

Assuming that bq command line executor is a part of Google Cloud SDK tools set:

Google Cloud SDK is a set of tools that you can use to manage resources and applications hosted on Google Cloud Platform. These include the gcloud, gsutil, and bq command line tools.

You have to install Google Cloud SDK on your client machine in order to leverage command line managing tools, if you are not using GCP Cloud Shell, where all the necessary SDK components are already pre-installed and up to date.

Generally BigQuery web UI graphical interface designed for running SQL queries based on DDL and DML statements, but useless for executing any kind of command line utils.