Port remaining dbt models from old warehouses to new elt-pipelines

[martyngigg]

The new ingest pipelines being generated by the work in #321 are complete. There remains the issue of migrating the existing dbt models from warehouses/facility_ops/transform/models to elt-pipelines/facility_ops/transform/models. This is not a simple copy of the files as the column names in most staging tables will have changed.

The task is to open a separate pull request per model in warehouses/facility_ops/transform/models/marts and

• copy the model .sql and .yml to the appropriate directory in elt-pipelines/facility_ops/transform/models/marts
• find the referenced staging models and also copy those to the appropriate elt-pipelines/facility_ops/transform/models/staging directory.
• update the names of the columns referenced in the ingested tables.

You'll need to get the credentials for each ingest pipeline in order to run them and discover the new column names for the ingested. Ask how to get them from the Vault.

[ambolt314]

dbt model checklist:

• OPRALOGWEB
• STATUS_DISPLAY
• ACCELERATOR_SHAREPOINT

[martyngigg]

I've just spotted that we missed copying over

• mcr_equipment_downtime_records
• mcr_equipment_downtime_uncategorized_equipment

from https://github.com/ISISNeutronMuon/analytics-data-platform/tree/7095b14714b4c7df5768fe1369b42d2e6570b661/warehouses/facility_ops/transform/models/marts/accelerator in #462. I didn't spot that on the pull request as we were focused on the staging models.