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

New task to refresh some materialized views #110

Open
dadiorchen opened this issue Oct 12, 2022 · 2 comments
Open

New task to refresh some materialized views #110

dadiorchen opened this issue Oct 12, 2022 · 2 comments
Assignees

Comments

@dadiorchen
Copy link
Contributor

On the db, there are some materialized views:

treetracker=> \dm webmap.*
                      List of relations
 Schema |         Name          |       Type        |  Owner
--------+-----------------------+-------------------+---------
 webmap | organization_location | materialized view | doadmin
 webmap | planter_location      | materialized view | doadmin
 webmap | species_stat          | materialized view | doadmin

So, we need to periodically update these views:
organization_location: daily
planter_location: daily
species_stat: daily

Please create 3 new dags to run the updates seperately.

@CareyAltgilbers
Copy link
Collaborator

Dadior, I can give this issue a try. Do you need this completed by a specific date since it is high-priority?

@dadiorchen
Copy link
Contributor Author

No, but the sooner the better :)
And you don't need to wait for review on this task, you can freely creat PR and merge into master to try it

@CareyAltgilbers CareyAltgilbers self-assigned this Oct 29, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants