may I ask some help about accessing detailed error log for failed transfer in BigQuery?
I have this message in the transfer run details (some data is altered to keep anonymity):
Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 610; errors: 1. Please look into the errors[] collection for more details. File: gs://balbal/asdaf-2413-b40a-582429aeca8c/65ddb1c3-qwertz-24058881afd4/whatever-2_20240302010612.json; JobID: 306617459295:bqts_65e10910-14223bc9779a
- In the LogsExplorer I can not found any errors[] collection.
- I tried to get the content in CloudShell with bq --format=prettyjson show -j where I used the whole JobID which is described above.
- I tried to load the gs:// address, replacing the gs:// protocll to https://storage.googleapis.com/ but I got access denied response.
So how can I access the content of the gs://balbal/asdaf-2413-b40a-582429aeca8c/65ddb1c3-qwertz-24058881afd4/whatever-2_20240302010612.json?
Thank you for your help in advance, Sandor