Load video intelligence results into a BigQuery database

[GA23]

I've run the google object detection and logo recognition examples online. I need a way to load this into a data table. I have tried using pandas dataframe but have run into a number of issues with the data structure (i.e. hard to flatten out the data). I have just tried it with Big Query on cloud using the instructions here:

https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-json#console

but again I am running into errors. 

"Error while reading data, error message: Failed to parse JSON: Unexpected end of string; Unexpected end of string; Expected key"

Does anyone know why this may be failing or how to fix? Sample JSON file attached.

[Kevin]

Hello,

Thanks for the feedback.

One of the limitations of loading JSON files from Cloud Storage is that JSON data must be newline delimited. Each JSON object must be on a separate line in the file. (Check out this answer from a Googler).

But please remind that Google Groups are reserved for general product discussion, StackOverflow for technical questions whereas Issue Tracker for product issues (unexpected behaviors) and feature requests (Reference).

Therefore, should you experience further issue in this matter, I suggest that, in order to get the best support and, depending on whether you think it is a product issue or a code/configuration issue, to post your question on the appropriate channel.

Best regards.