Convert json file to table

[Sindhura1]

I have json file in my cloud storage bucket and I need to store into bigquery table.

Can someone please help me with this.​

[Anonymous]

Hello,

Are you trying to load your json file from Google Cloud Storage?

Firstly, you can create a connection to Google Cloud Storage and download the file from GS.

After that, extracting the information from the json file.

The work flow should be: tGSConnection-->tGSGet-->onsubjobok-->tfileinputjson-->tExtractJsonField-->tBigQueryOutput

Let us know if it works.

Best regards

Sabrina

[Sindhura1]

Hi Sabrina,

Thanks for your response.​ But I have multiple JSON files with different structure and need to handle them dynamically.

And also to load json file to bigquery.it should be Newline delimited json file.

But mine is not.