Problem

Blocked by #4148

This issue tracks adding the final steps of the data refresh to the new DAGs.

Description

The final steps will be added to the DAGs:

• Create and Populated Filtered Index: this should be implemented as a reusable TaskGroup. This work can already be implemented using our existing Elasticsearch tasks and replaces this function.
• Reapply Constraints and Promote Table: these SQL queries can be performed with the PostgresHook, and replaces this function.
• Promote Index and Delete Index: these can be implemented using our existing Elasticsearch tasks, and replaces these functions.

Additional context

See this section of the IP.