How can I decompose "from-to term" to each date record ?
BigQuery(BQ) is very useful for data analysis or processing.
It is good at handling huge data. It returns summary result in short time.
BQ can handle date data.
Then we would like to handle "from-to" record like below.
| date_from | date_to |
|---|---|
| 2021-11-01 | 2021-11-05 |
Once we get this record, we want to convert it to each date like below.
| date |
|---|
| 2021-11-01 |
| 2021-11-02 |
| 2021-11-03 |
| 2021-11-04 |
| 2021-11-05 |
So how can we decompose "from-to term" to each date record ?
So today I introduce about "How to decompose "from-to term" to each date record in BigQuery".
This article was moved.
![Pinterest](https://www.pinterest.com/pin/create/button/?url=https%3A%2F%2Fitips.krsw.biz%2Fbigquery-how-to-convert-from-to-term-to-each-day-records%2F&media=https://itips.krsw.biz/wp-content/uploads/2020/10/h2-db.jpg&description=How can I decompose "from-to term" to each date record ? BigQuery(BQ) is very useful for d){kind=link}