10:22:32  Running with dbt=1.12.5
10:22:32  Registered adapter: duckdb=1.11.0
10:22:33  Unable to do partial parsing because a project config has changed
10:22:38  Found 2 models, 28 data tests, 2 seeds, 2 sources, 500 macros
10:22:38
10:22:38  Concurrency: 4 threads (target='dev')
10:22:38
10:22:38  1 of 26 START sql table model main_silver.stg_orders ........................... [RUN]
10:22:39  1 of 26 OK created sql table model main_silver.stg_orders ...................... [OK in 0.65s]
10:22:39  4 of 26 START test assert_quantity_positive .................................... [RUN]
10:22:39  5 of 26 START test not_null_stg_orders_order_id ................................ [RUN]
10:22:39  2 of 26 START test accepted_values_stg_orders_product__bread__brioche__cookie__croissant__donut__drink  [RUN]
10:22:39  3 of 26 START test accepted_values_stg_orders_quantity__False__1__2__3__4__5 ... [RUN]
10:22:39  4 of 26 PASS assert_quantity_positive .......................................... [PASS in 0.62s]
10:22:40  5 of 26 PASS not_null_stg_orders_order_id ...................................... [PASS in 0.64s]
10:22:40  6 of 26 START test not_null_stg_orders_product ................................. [RUN]
10:22:40  7 of 26 START test not_null_stg_orders_quantity ................................ [RUN]
10:22:40  2 of 26 PASS accepted_values_stg_orders_product__bread__brioche__cookie__croissant__donut__drink  [PASS in 0.68s]
10:22:40  8 of 26 START test not_null_stg_orders_user_id ................................. [RUN]
10:22:40  3 of 26 PASS accepted_values_stg_orders_quantity__False__1__2__3__4__5 ......... [PASS in 0.77s]
10:22:40  9 of 26 START test unique_stg_orders_order_id .................................. [RUN]
10:22:40  6 of 26 PASS not_null_stg_orders_product ....................................... [PASS in 0.36s]
10:22:40  7 of 26 PASS not_null_stg_orders_quantity ...................................... [PASS in 0.36s]
10:22:40  8 of 26 PASS not_null_stg_orders_user_id ....................................... [PASS in 0.29s]
10:22:40  9 of 26 PASS unique_stg_orders_order_id ........................................ [PASS in 0.24s]
10:22:40  10 of 26 START sql table model main_silver.stg_users ........................... [RUN]
10:22:40  10 of 26 OK created sql table model main_silver.stg_users ...................... [OK in 0.17s]
10:22:40  14 of 26 START test assert_orders_after_user_birth ............................. [RUN]
10:22:40  11 of 26 START test accepted_values_stg_users_birthdate_is_valid__False__True__False  [RUN]
10:22:40  13 of 26 START test assert_birthdate_cleaning .................................. [RUN]
10:22:40  12 of 26 START test accepted_values_stg_users_sex__F__M ........................ [RUN]
10:22:41  14 of 26 PASS assert_orders_after_user_birth ................................... [PASS in 0.35s]
10:22:41  15 of 26 START test assert_orders_have_users ................................... [RUN]
10:22:41  13 of 26 PASS assert_birthdate_cleaning ........................................ [PASS in 0.37s]
10:22:41  12 of 26 PASS accepted_values_stg_users_sex__F__M .............................. [PASS in 0.38s]
10:22:41  11 of 26 PASS accepted_values_stg_users_birthdate_is_valid__False__True__False . [PASS in 0.40s]
10:22:41  16 of 26 START test assert_username_normalized ................................. [RUN]
10:22:41  17 of 26 START test assert_zip_matches_state ................................... [RUN]
10:22:41  18 of 26 START test not_null_stg_users_birthdate_is_valid ...................... [RUN]
10:22:41  16 of 26 PASS assert_username_normalized ....................................... [PASS in 0.34s]
10:22:41  15 of 26 PASS assert_orders_have_users ......................................... [PASS in 0.42s]
10:22:41  18 of 26 PASS not_null_stg_users_birthdate_is_valid ............................ [PASS in 0.34s]
10:22:41  19 of 26 START test not_null_stg_users_email ................................... [RUN]
10:22:41  21 of 26 START test not_null_stg_users_user_id ................................. [RUN]
10:22:41  20 of 26 START test not_null_stg_users_state ................................... [RUN]
10:22:41  19 of 26 PASS not_null_stg_users_email ......................................... [PASS in 0.33s]
10:22:41  21 of 26 PASS not_null_stg_users_user_id ....................................... [PASS in 0.33s]
10:22:41  17 of 26 WARN 43 assert_zip_matches_state ...................................... [WARN 43 in 0.74s]
10:22:41  22 of 26 START test not_null_stg_users_username_normalized ..................... [RUN]
10:22:41  23 of 26 START test relationships_stg_orders_user_id__user_id__ref_stg_users_ .. [RUN]
10:22:41  20 of 26 PASS not_null_stg_users_state ......................................... [PASS in 0.37s]
10:22:41  24 of 26 START test relationships_stg_users_state__code__ref_states_ ........... [RUN]
10:22:42  25 of 26 START test unique_stg_users_email ..................................... [RUN]
10:22:42  23 of 26 PASS relationships_stg_orders_user_id__user_id__ref_stg_users_ ........ [PASS in 0.43s]
10:22:42  26 of 26 START test unique_stg_users_user_id ................................... [RUN]
10:22:42  22 of 26 PASS not_null_stg_users_username_normalized ........................... [PASS in 0.47s]
10:22:42  25 of 26 PASS unique_stg_users_email ........................................... [PASS in 0.33s]
10:22:42  24 of 26 PASS relationships_stg_users_state__code__ref_states_ ................. [PASS in 0.40s]
10:22:42  26 of 26 PASS unique_stg_users_user_id ......................................... [PASS in 0.09s]
10:22:42
10:22:42  Finished running 2 table models, 24 data tests in 0 hours 0 minutes and 4.41 seconds (4.41s).
10:22:42
10:22:42  Completed with 1 warning:
10:22:42
10:22:42  [WARNING]: in test assert_zip_matches_state (tests/assert_zip_matches_state.sql)
10:22:42  [WARNING]: Got 43 results, configured to warn if != 0
10:22:42
10:22:42    compiled code at target/compiled/lab_medallion/tests/assert_zip_matches_state.sql
10:22:42
10:22:42    See test failures:
  -------------------------------------------------------------------------------
  select * from "lab_medallion"."main_dbt_test__audit"."assert_zip_matches_state"
  -------------------------------------------------------------------------------
10:22:42
10:22:42  Done. PASS=25 WARN=1 ERROR=0 SKIP=0 NO-OP=0 REUSED=0 TOTAL=26
