I have Json data which is saved in bigquery, i want to seperate json to table
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?