I have a BigQuery DB with two columns:
Date
Value
I have an HTTP request that sends back dates and values for each of those dates. I want to update a BigQuery Database with the date and corresponding value. I can’t figure out how to “combine” and iterate on these values. Any help is appreciated!
Ultimately I want 9 iterations updating the two columns in my BigQuery DB So I’m left with:
| date | value |
|---|---|
| 1730793600.59 | 4 |
| 1730880000.59 | 10 |
| 1730966400.59 | 8 |
| 1731052800.59 | 5 |
| 1731130200.59 | 4 |
| 1731225600.59 | 5 |
| 1731312000.59 | 8 |
| 1731398400.59 | 7 |
| 1731484800.59 | 3 |
I’ll ultimately parse the date… but for the purpose of the example matching the image, I’m using the X date.
