No Metadata check supported for SQL input type under Unit Test

[VinhTruongDBT]

Describe the Feature & Concerns

Currently, unit tests do not perform metadata checks against any model for SQL input types, unlike for dictionary and CSV formats. This oversight results in unit tests passing even when users input incorrect column names (i.e., non-existent columns)

 unit_test:
- name : unit_test_name
   model: target_model
   given: 
      - input : ref( input_model)
        format:  sql 
        rows:  |
          select '1234' as temp_id 
   expect:
        format:  sql 
        rows:  |
          select '1234' as temp_id

Outcome

Unit test pass without error
**PASS = 1** WARN = 0 ERROR = 0 SKIP=0 TOTAL= 1

Expected Outcome

Unit test failed with error column temp_id does not exsited .

Describe alternatives you've considered

A meta data check is required for SQL input format like csv and dictionary.

Who will this benefit?

Users will conduct unit test in DBT under SQL input type format

Are you interested in contributing this feature?

we would love further advancing this features if needed