running "make local" results in Database Error in model raw_contacts

[mrjones-plip]

Hi there! When I follow the steps on the readme, I get the following error repeatedly in the dbt container Database Error in model raw_contacts (models/contact_views/raw_contacts.sql).

Here's the complete logs from docker logs pipeline-dbt-1

22:52:47  Found 5 models, 0 tests, 0 snapshots, 0 analyses, 307 macros, 0 operations, 0 seed files, 0 sources, 0 exposures, 0 metrics, 0 groups
22:52:47  
22:52:47  Concurrency: 1 threads (target='dev')
22:52:47  
22:52:47  1 of 5 START sql view model dbt.couchdb ........................................ [RUN]
22:52:47  1 of 5 OK created sql view model dbt.couchdb ................................... [CREATE VIEW in 0.13s]
22:52:47  2 of 5 START sql incremental model dbt.data_record ............................. [RUN]
22:52:47  2 of 5 OK created sql incremental model dbt.data_record ........................ [INSERT 0 1 in 0.13s]
22:52:47  3 of 5 START sql incremental model dbt.person .................................. [RUN]
22:52:48  3 of 5 OK created sql incremental model dbt.person ............................. [INSERT 0 8 in 0.08s]
22:52:48  4 of 5 START sql view model dbt.raw_contacts ................................... [RUN]
22:52:48  4 of 5 ERROR creating sql view model dbt.raw_contacts .......................... [ERROR in 0.03s]
22:52:48  5 of 5 SKIP relation dbt.contactview_metadata .................................. [SKIP]
22:52:48  
22:52:48  Finished running 3 view models, 2 incremental models in 0 hours 0 minutes and 0.52 seconds (0.52s).
22:52:48  
22:52:48  Completed with 1 error and 0 warnings:
22:52:48  
22:52:48  Database Error in model raw_contacts (models/contact_views/raw_contacts.sql)
22:52:48    syntax error at or near ";"
22:52:48    LINE 10: ...ct_hospital'::text, 'health_center'::text, 'person'::text]);
22:52:48                                                                           ^
22:52:48    compiled Code at target/run/pipeline/models/contact_views/raw_contacts.sql
22:52:48  
22:52:48  Done. PASS=3 WARN=0 ERROR=1 SKIP=1 TOTAL=5
22:52:58  Running with dbt=1.5.0

Steps to reproduce:

1. clone this repo locally: git clone https://github.com/medic/cht-sync
2. change directory: cd cht-sync
3. copy env file: cp env.template .env
4. start local instance: make local

expected: no errors actual: errors

related: checking the SQL instance I do see rows are being added successfully on regular intervals

[samuelimoisili]

This issue has been fixed on cht-pipeline with the new default models PR