Hi!
We have model patient_management.v_patient_insurance in sqlmesh but it's not created. Plan or Run, doesn't re-create etc and there is no error as well.
We can delete and then re-add it and it will be created but don't know why SQLMesh is not able to identify it.
SQL Error [42P01]: ERROR: relation "patient_management.v_patient_insurance" does not exist
Position: 15
Error position: line: 1740 pos: 14
dotenvx run -- sqlmesh run --skip-janitor --ignore-cron --select-model="patient_management.v_patient_insurance"
⟐ injected env (1) from .env · dotenvx@1.61.0
[v1.0.0] Copy to blob: Object=dbo.vm_SaviPatientInsurance;Blob=;Container=reports-savi
[v1.0.0] Updating fields of table: Name="postgres"."sqlmesh__data_pipeline"."data_pipeline__ext_pt_ins__2065245981"
[v1.0.0] Analyzing table: Name="postgres"."sqlmesh__data_pipeline"."data_pipeline__ext_pt_ins__2065245981"
[1/1] data_pipeline.ext_pt_ins [full refresh] 7.04s
[1/1] data_pipeline.external_patient_insurance [recreate view] 2.92s
[1/1] patient_management.v_patient_insurance [recreate view] 1.46s
Executing model batches ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 100.0% • 3/3 • 0:00:26
✔ Model batches executed
Run finished for environment 'prod'
Thanks
Hi!
We have model
patient_management.v_patient_insurancein sqlmesh but it's not created. Plan or Run, doesn't re-create etc and there is no error as well.We can delete and then re-add it and it will be created but don't know why SQLMesh is not able to identify it.
Thanks