Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add forecast latest table #2

Closed
peterdudfield opened this issue Jan 18, 2022 · 2 comments · Fixed by #54
Closed

Add forecast latest table #2

peterdudfield opened this issue Jan 18, 2022 · 2 comments · Fixed by #54
Assignees

Comments

@peterdudfield
Copy link
Contributor

peterdudfield commented Jan 18, 2022

Detailed Description

Add latest table of forecast, which just holds the latest forecast for that given target time. This makes it easy to load, but all the history is saved in a different table

Possible Implementation

Seperate SQL table for saving latest results. Use primary key across target_datetime_utc, gsp_id

Should also update save method to save to this table too

@peterdudfield peterdudfield transferred this issue from another repository Jan 18, 2022
@peterdudfield peterdudfield transferred this issue from openclimatefix/nowcasting_forecast Feb 7, 2022
@peterdudfield
Copy link
Contributor Author

To expand a bit.

We would have a table that would just save the latest Forecast for each gsp location. We could also have a table for 'ForecastValueSQL' so only the latest forecast values are saved there. This will make loading very quick. The full historic will be saved somewhere else

@peterdudfield
Copy link
Contributor Author

The forecast can write the current table and then update this table too

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
No open projects
Status: Done
Development

Successfully merging a pull request may close this issue.

1 participant