19:20:32 Finished running 76 view models, 86 seeds, 240 table models, 57 data tests in 0 hours 0 minutes and 11.71 seconds (11.71s).
19:20:32
19:20:32 Completed with 53 errors and 0 warnings:
19:20:32
19:20:32 Database Error in model core__stg_clinical_condition (models/core/staging/core__stg_clinical_condition.sql)
operator does not exist: date ~ text
LINE 15: when recorded_date similar to '[0-9]{4}-[0-9]{2}-[0-9]...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_condition.sql
19:20:32
19:20:32 Database Error in model core__stg_clinical_encounter (models/core/staging/core__stg_clinical_encounter.sql)
operator does not exist: date ~ text
LINE 14: when encounter_start_date similar to '[0-9]{4}-[0-9]{2...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_encounter.sql
19:20:32
19:20:32 Database Error in model core__stg_clinical_medication (models/core/staging/core__stg_clinical_medication.sql)
operator does not exist: date ~ text
LINE 14: when dispensing_date similar to '[0-9]{4}-[0-9]{2}-[0-...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_medication.sql
19:20:32
19:20:32 Database Error in model core__stg_clinical_patient (models/core/staging/core__stg_clinical_patient.sql)
operator does not exist: date ~ text
LINE 16: when birth_date similar to '[0-9]{4}-[0-9]{2}-[0-9]{2}...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_patient.sql
19:20:32
19:20:32 Database Error in model core__stg_clinical_procedure (models/core/staging/core__stg_clinical_procedure.sql)
operator does not exist: date ~ text
LINE 15: when procedure_date similar to '[0-9]{4}-[0-9]{2}-[0-9...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_procedure.sql
19:20:32
19:20:32 Database Error in model core__stg_clinical_lab_result (models/core/staging/core__stg_clinical_lab_result.sql)
operator does not exist: date ~ text
LINE 25: when result_date similar to '[0-9]{4}-[0-9]{2}-[0-9]{2...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_lab_result.sql
19:20:32
19:20:32 Database Error in model core__stg_clinical_observation (models/core/staging/core__stg_clinical_observation.sql)
operator does not exist: date ~ text
LINE 16: when observation_date similar to '[0-9]{4}-[0-9]{2}-[0...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_clinical_observation.sql
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__medication_patient_id.0aaf3a0652, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__medication
19:20:32
19:20:32 Database Error in model data_quality__claims_preprocessing_eligibility_denominators (models/data_quality/claims_preprocessing/intermediate/data_quality__claims_preprocessing_eligibility_denominators.sql)
syntax error at or near ")"
LINE 33: )
^
compiled Code at target/run/the_tuva_project/models/data_quality/claims_preprocessing/intermediate/data_quality__claims_preprocessing_eligibility_denominators.sql
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.hcc_suspecting__int_prep_egfr_labs, caused by compilation error in referenced ephemeral model model.the_tuva_project.hcc_suspecting__stg_core__lab_result
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__observation_patient_id.31e33f2d7e, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__observation
19:20:32
19:20:32 Database Error in model data_quality__claims_preprocessing_medical_claim_denominators (models/data_quality/claims_preprocessing/intermediate/data_quality__claims_preprocessing_medical_claim_denominators.sql)
syntax error at or near ")"
LINE 56: )
^
compiled Code at target/run/the_tuva_project/models/data_quality/claims_preprocessing/intermediate/data_quality__claims_preprocessing_medical_claim_denominators.sql
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_shared_exclusion_missing_age, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_shared_exclusion_missing_gender, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.cms_hcc__int_members, caused by compilation error in referenced ephemeral model model.the_tuva_project.cms_hcc__stg_core__patient
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.accepted_values_quality_measures__stg_core__patient_sex__female__male__unknown.e6adc9ce2b, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__patient
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__patient_birth_date.4b3a2e74e6, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__patient
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__patient_patient_id.5510e1a0fd, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__patient
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__patient_sex.e2f34cab69, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.hcc_suspecting__int_all_medications, caused by compilation error in referenced ephemeral model model.the_tuva_project.hcc_suspecting__stg_core__medication
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_01_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_03_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_05_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_07_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_08_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_11_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_12_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_14_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_15_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_16_denom, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_patient
19:20:32
19:20:32 Database Error in model core__stg_claims_condition (models/core/staging/core__stg_claims_condition.sql)
operator does not exist: date ~ text
LINE 503: when unpivot_cte.recorded_date similar to '[0-9]{4}-[0...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_claims_condition.sql
19:20:32
19:20:32 Database Error in model core__stg_claims_medical_claim (models/core/staging/core__stg_claims_medical_claim.sql)
operator does not exist: date ~ text
LINE 36: when med.claim_start_date similar to '[0-9]{4}-[0-9]{2...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_claims_medical_claim.sql
19:20:32
19:20:32 Database Error in model core__stg_claims_procedure (models/core/staging/core__stg_claims_procedure.sql)
operator does not exist: date ~ text
LINE 511: when unpivot_cte.procedure_date similar to '[0-9]{4}-[...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_claims_procedure.sql
19:20:32
19:20:32 Database Error in model core__stg_claims_encounter (models/core/staging/core__stg_claims_encounter.sql)
operator does not exist: date ~ text
LINE 25: when encounter_start_date similar to '[0-9]{4}-[0-9]{2...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
compiled Code at target/run/the_tuva_project/models/core/staging/core__stg_claims_encounter.sql
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ccsr__long_condition_category, caused by compilation error in referenced ephemeral model model.the_tuva_project.ccsr__stg_core__condition
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.chronic_conditions__cms_chronic_conditions_hiv_aids, caused by compilation error in referenced ephemeral model model.the_tuva_project.cms_chronic_conditions__stg_core__condition
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.hcc_suspecting__int_prep_conditions, caused by compilation error in referenced ephemeral model model.the_tuva_project.hcc_suspecting__stg_core__condition
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__condition_patient_id.1f1222e348, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__condition
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.chronic_conditions__tuva_chronic_conditions_long, caused by compilation error in referenced ephemeral model model.the_tuva_project.tuva_chronic_conditions__stg_core__condition
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.cms_hcc__int_eligible_conditions, caused by compilation error in referenced ephemeral model model.the_tuva_project.cms_hcc__stg_core__medical_claim
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.financial_pmpm__patient_spend_with_service_categories, caused by compilation error in referenced ephemeral model model.the_tuva_project.financial_pmpm__stg_medical_claim
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.quality_measures__int_shared_exclusions_institutional_snp, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_medical_claim
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ccsr__long_procedure_category, caused by compilation error in referenced ephemeral model model.the_tuva_project.ccsr__stg_core__procedure
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.chronic_conditions__cms_chronic_conditions_all, caused by compilation error in referenced ephemeral model model.the_tuva_project.cms_chronic_conditions__stg_core__procedure
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__procedure_patient_id.0b52ff75d9, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__procedure
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.readmissions__procedure_ccs, caused by compilation error in referenced ephemeral model model.the_tuva_project.readmissions__stg_core__procedure
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_shared_exclusion_missing_dates, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_inpatient_encounter
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_shared_exclusion_missing_primary_dx, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_inpatient_encounter
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_shared_exclusion_transfer, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_inpatient_encounter
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ahrq_measures__int_pqi_shared_exclusion_ungroupable_drg, caused by compilation error in referenced ephemeral model model.the_tuva_project.ahrq_measures__stg_pqi_inpatient_encounter
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.ed_classification__int_map_primary_dx, caused by compilation error in referenced ephemeral model model.the_tuva_project.ed_classification__stg_encounter
19:20:32
19:20:32 Compilation Error in test.the_tuva_project.not_null_quality_measures__stg_core__encounter_patient_id.a0d82e2159, caused by compilation error in referenced ephemeral model model.the_tuva_project.quality_measures__stg_core__encounter
19:20:32
19:20:32 Compilation Error in model.the_tuva_project.readmissions__encounter, caused by compilation error in referenced ephemeral model model.the_tuva_project.readmissions__stg_core__encounter