I have this table in Snowflake:
| DATE | ID | REVENUE |
|---|---|---|
| 2023-01-01 | NULL | NULL |
| 2024-03-11 | 1 | 34.00 |
| 2024-03-11 | 2 | 10.00 |
| 2024-03-12 | NULL | NULL |
| 2023-03-12 | 2 | 15.00 |
| 2024-03-13 | NULL | NULL |
| 2024-03-14 | 1 | 38.90 |
| 2024-03-15 | NULL | NULL |
I want to be able to write a SQL query that will fill and populate all the NULLs so it ends up like this, essentially filling for each date since the first record for each ID:
| DATE | ID | REVENUE |
|---|---|---|
| 2023-01-01 | NULL | NULL |
| 2024-03-11 | 1 | 34.00 |
| 2024-03-11 | 2 | 10.00 |
| 2024-03-12 | 1 | 34.00 |
| 2023-03-12 | 2 | 15.00 |
| 2024-03-13 | 1 | 34.00 |
| 2023-03-13 | 2 | 15.00 |
| 2024-03-14 | 1 | 38.90 |
| 2024-03-14 | 2 | 15.00 |
| 2024-03-15 | 1 | 38.90 |
| 2024-03-15 | 2 | 15.00 |
| 2024-03-16 | 1 | 38.90 |
| 2024-03-16 | 2 | 15.00 |