0

I have Json data which is saved in bigquery, i want to seperate json to table

enter image description here

Row                 jobStatistics
                      JSON
1   
                  {
                   billingTier: 1
                   createTime: "2023-01-14T10:03:57.605Z"
                   endTime: "2023-01-14T10:04:10.476Z"
                   queryOutputRowCount: "417653"
                   referencedTables: [2]
                   startTime: "2023-01-14T10:03:57.659Z"
                   totalBilledBytes: "671088640"
                   totalProcessedBytes: "670635727"
                   totalSlotMs: "64184"
                   totalTablesProcessed: 2
                  } 

I want to have a result set where each process will be in a different row. Something like:

totalBilledBytes totalTablesProcessed createTime
671088640 2 2023-01-14T10:03:57.605Z

Or, is there a different way to return the desired result set?

Jaytiger
  • 11,626
  • 2
  • 5
  • 15
Viet Van
  • 1
  • 1

0 Answers0