microsoft / dbt-fabric

MIT License
79 stars 28 forks source link

Store Failures flag will generate model w/o failure #234

Open TheBishop-98 opened 1 month ago

TheBishop-98 commented 1 month ago

We are encountering an issue that the --store-failures flag will generate a model even when the test passes. All of my claims test tables are blanks when they should not be created because the tests passed?

Project yaml:


data_tests:
  HMA_DBT_ENTERPRISE:
    +store_failures_as: table
    +database: DataMarts 
    +schema: data_tests

Model yaml:


- name: company_id
  description: "{{ doc('acl_companyID')}}"
  data_tests:
    - relationships:
        to: ref('stg_ACL_COMPANIES')
        field: company_id
        config:
          severity: warn
  data_type: varchar(8000)

- name: line_of_coverage_id
  description: "{{ doc('acl_lineOfCoverageID')}}"
  data_tests:
    - relationships:
        to: ref('stg_ACL_LINES_OF_COVERAGE')
        field: line_of_coverage_id
        config:
          severity: warn
  data_type: varchar(8000)

Image Image