Skip to content

Model is missing but sqlmesh plan/run is successful #5765

@wahmedswl

Description

@wahmedswl

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions