Ephemeral Model Error w/Postgres

[amr-abouelleil-ic]

Describe the bug
I have successfully installed the tuva project demo and used dbt build to load the demo data into snowflake. When I try to do this with a local postgres DB, however, I get the following errors after running dbt build:

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

To Reproduce
Steps to reproduce the behavior:

1. In the profiles yaml file, create a profile for connecting to a local postgres install.
2. run dbt build
3. See errors as listed above
4. Note that the database tables are created, but they have no data.

Expected behavior
I expected that database tables in my local postgres instance to have the same demo data as I saw in Snowflake.

Environment

• Package version (e.g. 0.6.0):
• Data warehouse (e.g. Snowflake): postgres

Additional context
dbt version 1.8.1

[sarojbelbase]

I encounter the same issue when seeding data, and the seeds don't load; they are skipped. I also attempted using postgres-loader, and it has the same issue.