Pipeline Refresh & Orchestration
Freshness
Evidence-led pipeline health from source systems through raw landing, dbt, API surfaces, dashboards and Adaa export readiness.
34%Pipeline health score
Freshness Heatmap
Layer health, object age, row count and upstream dependency
raw_upload
raw_upload.strategy_objectiveswarning - No timestamp45 rowsCSV seed
raw_upload.kpi_catalogwarning - No timestamp250 rowsCSV seed
raw_upload.kpi_actualsstale - 302 d6,000 rowsCSV seed
raw_upload.initiativeswarning - No timestamp200 rowsCSV seed
raw_upload.initiative_kpi_linkswarning - No timestamp398 rowsCSV seed
raw_upload.initiative_milestoneswarning - No timestamp801 rowsCSV seed
raw_upload.initiative_deliverableswarning - No timestamp601 rowsCSV seed
raw_upload.initiative_budget_actualsstale - 97 d1,200 rowsCSV seed
raw_upload.initiative_benefitsstale - 97 d1,200 rowsCSV seed
raw_upload.actionsstale - 244 d300 rowsCSV seed
raw_upload.decisionsstale - 299 d120 rowsCSV seed
raw_upload.data_sourceswarning - No timestamp6 rowsCSV seed
raw_upload.field_dictionarywarning - No timestamp24 rowsCSV seed
raw_upload.classification_registerwarning - No timestamp24 rowsCSV seed
raw_upload.dbt_model_registrystale - 461 d7 rowsCSV seed
raw_upload.r_runtime_model_registrystale - 461 d4 rowsCSV seed
raw_upload.job_scheduleswarning - No timestamp8 rowsCSV seed
raw_airbyte
raw_airbyte.actionsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.bed_pressure_bed_eventsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.bed_pressure_patientsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.bed_pressure_wardsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.classification_registernot configured - No timestamp0 rowsAirbyte
raw_airbyte.data_sourcesnot configured - No timestamp0 rowsAirbyte
raw_airbyte.dbt_model_registrynot configured - No timestamp0 rowsAirbyte
raw_airbyte.decisionsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.early_warning_alertsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.field_dictionarynot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiative_benefitsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiative_budget_actualsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiative_deliverablesnot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiative_kpi_linksnot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiative_milestonesnot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiative_progress_historynot configured - No timestamp0 rowsAirbyte
raw_airbyte.initiativesnot configured - No timestamp0 rowsAirbyte
raw_airbyte.job_schedulesnot configured - No timestamp0 rowsAirbyte
raw_airbyte.kpi_actualsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.kpi_catalognot configured - No timestamp0 rowsAirbyte
raw_airbyte.milestone_progress_historynot configured - No timestamp0 rowsAirbyte
raw_airbyte.mops_test_again_districtsstale - 109 d7 rowsAirbyte
raw_airbyte.mops_test_again_early_warning_alertsstale - 109 d15 rowsAirbyte
raw_airbyte.mops_test_again_early_warning_alerts_airbyte_tmpstale - 109 d15 rowsAirbyte
raw_airbyte.mops_test_again_service_requestsstale - 109 d25 rowsAirbyte
raw_airbyte.mops_test_again_service_requests_airbyte_tmpstale - 109 d25 rowsAirbyte
raw_airbyte.mops_test_again_survey_satisfactionstale - 109 d21 rowsAirbyte
raw_airbyte.mops_test_again_survey_satisfaction_airbyte_tmpstale - 109 d21 rowsAirbyte
raw_airbyte.r_runtime_model_registrynot configured - No timestamp0 rowsAirbyte
raw_airbyte.service_requestsnot configured - No timestamp0 rowsAirbyte
raw_airbyte.strategy_objectivesnot configured - No timestamp0 rowsAirbyte
raw_airbyte.survey_satisfactionnot configured - No timestamp0 rowsAirbyte
admin_control
admin_control.refresh_requestsstale - 80 d14 rowsAdmin Control Plane
admin_control.pipeline_runsnot configured - No timestamp0 rowsAdmin Control Plane
admin_control.admin_audit_eventsstale - 84 d1 rowsAdmin Control Plane
admin_control.strategy_objectivesnot configured - No timestamp0 rowsAdmin Control Plane
admin_control.kpi_catalognot configured - No timestamp0 rowsAdmin Control Plane
admin_control.initiativesnot configured - No timestamp0 rowsAdmin Control Plane
admin_control.kpi_actualsnot configured - No timestamp0 rowsAdmin Control Plane
staging
staging.stg_actionsstale - 244 d300 rowsraw landing/admin_control
staging.stg_bed_pressure_bed_eventsnot configured - No timestamp0 rowsraw landing/admin_control
staging.stg_bed_pressure_patientsnot configured - No timestamp0 rowsraw landing/admin_control
staging.stg_bed_pressure_wardsnot configured - No timestamp0 rowsraw landing/admin_control
staging.stg_classification_registerwarning - No timestamp24 rowsraw landing/admin_control
staging.stg_data_sourceswarning - No timestamp6 rowsraw landing/admin_control
staging.stg_dbt_model_registrystale - 461 d7 rowsraw landing/admin_control
staging.stg_decisionsstale - 299 d120 rowsraw landing/admin_control
staging.stg_early_warning_alertswarning - No timestamp15 rowsraw landing/admin_control
staging.stg_field_dictionarywarning - No timestamp24 rowsraw landing/admin_control
staging.stg_initiative_benefitsstale - 97 d1,200 rowsraw landing/admin_control
staging.stg_initiative_budget_actualsstale - 97 d1,200 rowsraw landing/admin_control
staging.stg_initiative_deliverableswarning - No timestamp601 rowsraw landing/admin_control
staging.stg_initiative_kpi_linkswarning - No timestamp398 rowsraw landing/admin_control
staging.stg_initiative_milestoneswarning - No timestamp801 rowsraw landing/admin_control
staging.stg_initiative_progress_historystale - 278 d9 rowsraw landing/admin_control
staging.stg_initiativeswarning - No timestamp200 rowsraw landing/admin_control
staging.stg_job_scheduleswarning - No timestamp8 rowsraw landing/admin_control
staging.stg_kpi_actualsstale - 302 d6,000 rowsraw landing/admin_control
staging.stg_kpi_catalogwarning - No timestamp250 rowsraw landing/admin_control
staging.stg_milestone_progress_historystale - 278 d45 rowsraw landing/admin_control
staging.stg_r_runtime_model_registrystale - 461 d4 rowsraw landing/admin_control
staging.stg_service_requestswarning - No timestamp25 rowsraw landing/admin_control
staging.stg_strategy_objectiveswarning - No timestamp45 rowsraw landing/admin_control
staging.stg_survey_satisfactionwarning - No timestamp21 rowsraw landing/admin_control
analytics
analytics.dim_bed_pressure_patientnot configured - No timestamp0 rowsstaging
analytics.dim_bed_pressure_wardnot configured - No timestamp0 rowsstaging
analytics.dim_data_sourcewarning - No timestamp6 rowsstaging
analytics.dim_dbt_model_registrystale - 461 d7 rowsstaging
analytics.dim_job_schedulewarning - No timestamp8 rowsstaging
analytics.dim_kpi_hierarchywarning - No timestamp250 rowsstaging
analytics.dim_r_runtime_model_registrystale - 461 d4 rowsstaging
analytics.dim_strategy_objectivewarning - No timestamp45 rowsstaging
analytics.fct_actionsstale - 244 d300 rowsstaging
analytics.fct_bed_pressure_occupancynot configured - No timestamp0 rowsstaging
analytics.fct_decisionsstale - 299 d120 rowsstaging
analytics.fct_early_warning_alertswarning - No timestamp15 rowsstaging
analytics.fct_early_warning_kpistale - 52 d6 rowsstaging
analytics.fct_initiative_progresswarning - No timestamp200 rowsstaging
analytics.fct_initiative_progress_historystale - 278 d9 rowsstaging
analytics.fct_kpi_actualsstale - 52 d6,021 rowsstaging
analytics.fct_milestone_progress_historystale - 278 d45 rowsstaging
analytics.fct_objective_progress_historystale - 278 d1,089 rowsstaging
analytics.fct_service_requestsnot configured - No timestamp0 rowsstaging
analytics.fct_service_response_kpistale - 52 d13 rowsstaging
analytics.fct_survey_kpistale - 52 d2 rowsstaging
output/gold
output.adaa_submission_snapshotstale - 308 d6,000 rowsanalytics
output.admin_data_operations_snapshotstale - 461 d25 rowsanalytics
output.bed_pressure_dashboard_snapshotnot configured - No timestamp0 rowsanalytics
output.bed_pressure_governance_snapshotwarning - No timestamp1 rowsanalytics
output.initiative_portfolio_snapshotwarning - No timestamp200 rowsanalytics
output.kpi_cascade_snapshotstale - 308 d250 rowsanalytics
output.kpi_forecast_readinesswarning - No timestamp250 rowsanalytics
output.strategy_health_snapshotwarning - No timestamp45 rowsanalytics
API
FastAPI read surfacestale - 461 d7 rowsoutput/gold
dashboards
SC01-SC09 dashboardsstale - 461 d250 rowsFastAPI