This line change is causing errors in Redshift. These types of subqueries are not supported in Redshift.
16:58:02 Database Error in model readmissions__encounter_data_quality (models/readmissions/intermediate/readmissions__encounter_data_quality.sql)
This type of correlated subquery pattern is not supported due to internal error
compiled code at target/run/the_tuva_project/models/readmissions/intermediate/readmissions__encounter_data_quality.sql
https://github.com/tuva-health/tuva/blob/9b7c22589952b6500c5801bcf77755a1724565ca/models/readmissions/intermediate/readmissions__encounter_data_quality.sql#L58
This line change is causing errors in Redshift. These types of subqueries are not supported in Redshift.