I have been trying to manually upload the JSON into BigQuery, but I get the following error message. I already converted the file into newline delimited JSON, so that is not the problem. When looking at the custom_field.value from the error I get this: The problem seems to be that the custom_fields.value has different data types. How can I “homogenize”
Tag: google-bigquery
BigQuery can’t find job when using pagination
I’ve been using this AppScript function that I took from here with slight modifications and it seemed to work fine, it just takes in a query and returns a 2D array. However, if the query is big and comes back with more totalRows than rows and therefore requires pagination, the job doesn’t seem to be persistent and therefore I get