Hi everyone, is this expected behavior? When I delete a table monitored by schema_changes test, it results in

error

instead of

fail

-- I deleted data_dump.pivot_test before I run dbt test
-- Below is the result

Database Error in test elementary_source_schema_changes_data_dump_pivot_test_ (sources\sources.yml)
  syntax error at or near ")"
  LINE 41:             ) rt

I also attach a response regarding this by Elementary AI in the thread.

Hey Owen, apologize for the delay! We want to take a deeper look. What DWH are you using? Also, what versions of the Elementary dbt package and dbt are you using? Please share your

dbt.log

and the compiled code of the test. Thanks!

Hi @Noya Offer, thank you for your patience! Here are the details: • dbt: 1.7.0 • Elementary dbt package: 0.18.1 • DWH: PostgreSQL 14.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit Context • I added Elementary's schema change test to a source table called

data_dump.test_table

• I ran the command

dbt test -s source:data_dump

to initialize the schema test (schema test PASS) • I deleted the

data_dump.test_table

and ran the same command

dbt test -s source:data_dump

to check if the schema test gives me warning • The command gave error instead • I attached the log below, please tell me if you need the complete log Sources.yml

sources:
- name: data_dump
  database: "{{ env_var('DWH_DB') }}"
  schema: data_dump
  tables:
  - name: test_table
    tests:
      - elementary.schema_changes

cc: @Leonard Liauw