woodRock/psychic-invention

Update Views for other datastreams

woodRock opened this issue · 1 comments

woodRock commented

Goal

The materialized views for the other datastreams are not updated each time new data is added to the portal.

Tasklist

  • Moorings
    • Add SQL function to update views
    • Test
  • Fisheries
    • Add SQL function to update views
    • Test

Success Criteria

Ensure that the other data streams (mooring and fisheries) also update their materialized views when new data is ingested.

woodRock commented

This will need to copy the same process outlined in #30. The same code can be used for both, it will just need to be updated to match the structure for each table.