format python list stored in bucket storage to read it with Bigquery

  google-bigquery, google-cloud-storage, json, python

I have a simple list of items:

['item1', 'item2', 'item3', etc...]

They could belong to a bigger object called product.

I found that the following format work but item are nested under one row.

{'product': ['item1', 'item2', 'item3']}

How can I convert my list to have one item per row in bigquery with a column named product?

I’m running my code in python in a cloud function.

Source: Python Questions

LEAVE A COMMENT