Currently ALIS & SLIS suggestions are writing to the same partition and if one fails the other cannot run because the process to push the search weighted tags wait for both tasks to be sure that the partition is fully populated.
A more robust approach would be to decorelate the two jobs and let them push the tags themselves.
We should as well remove the intermediate table between search's image_suggestions_weekly dag and airflow-platform-eng's ALIS/SLIS dag.
The two airflow-platform-eng's ALIS/SLIS dags should probably own the push of weighted_tags and search's image_suggestions_weekly should disappear simplifying the maintenance burden of this process.
AC:
- SLIS/ALIS can push weighted tags independently of each others
- Use/adapt publish_page_change_weighted_tags.py to push the tags
- remove the need of search's image_suggestions_weekly DAG
- while at it try to solve T389643