10:22:17  Running with dbt=1.12.5
10:22:18  Registered adapter: duckdb=1.11.0
10:22:19  Found 28 data tests, 2 seeds, 2 models, 2 sources, 500 macros
10:22:19
10:22:19  Concurrency: 4 threads (target='dev')
10:22:19
10:22:20  1 of 26 START sql view model main_silver.stg_orders ............................ [RUN]
10:22:20  1 of 26 OK created sql view model main_silver.stg_orders ....................... [OK in 0.59s]
10:22:20  5 of 26 START test not_null_stg_orders_order_id ................................ [RUN]
10:22:20  3 of 26 START test accepted_values_stg_orders_quantity__False__1__2__3__4__5 ... [RUN]
10:22:20  4 of 26 START test assert_quantity_positive .................................... [RUN]
10:22:20  2 of 26 START test accepted_values_stg_orders_product__bread__brioche__cookie__croissant__donut__drink  [RUN]
10:22:22  2 of 26 PASS accepted_values_stg_orders_product__bread__brioche__cookie__croissant__donut__drink  [PASS in 1.18s]
10:22:22  6 of 26 START test not_null_stg_orders_product ................................. [RUN]
10:22:22  3 of 26 PASS accepted_values_stg_orders_quantity__False__1__2__3__4__5 ......... [PASS in 1.27s]
10:22:22  5 of 26 PASS not_null_stg_orders_order_id ...................................... [PASS in 1.32s]
10:22:22  4 of 26 PASS assert_quantity_positive .......................................... [PASS in 1.27s]
10:22:22  7 of 26 START test not_null_stg_orders_quantity ................................ [RUN]
10:22:22  8 of 26 START test not_null_stg_orders_user_id ................................. [RUN]
10:22:22  9 of 26 START test unique_stg_orders_order_id .................................. [RUN]
10:22:23  8 of 26 PASS not_null_stg_orders_user_id ....................................... [PASS in 0.80s]
10:22:23  6 of 26 PASS not_null_stg_orders_product ....................................... [PASS in 0.98s]
10:22:23  9 of 26 PASS unique_stg_orders_order_id ........................................ [PASS in 0.92s]
10:22:23  7 of 26 PASS not_null_stg_orders_quantity ...................................... [PASS in 0.94s]
10:22:23  10 of 26 START sql view model main_silver.stg_users ............................ [RUN]
10:22:23  10 of 26 OK created sql view model main_silver.stg_users ....................... [OK in 0.35s]
10:22:23  12 of 26 START test accepted_values_stg_users_sex__F__M ........................ [RUN]
10:22:23  11 of 26 START test accepted_values_stg_users_birthdate_is_valid__False__True__False  [RUN]
10:22:23  13 of 26 START test assert_birthdate_cleaning .................................. [RUN]
10:22:23  14 of 26 START test assert_orders_after_user_birth ............................. [RUN]
10:22:24  12 of 26 PASS accepted_values_stg_users_sex__F__M .............................. [PASS in 0.94s]
10:22:24  11 of 26 PASS accepted_values_stg_users_birthdate_is_valid__False__True__False . [PASS in 0.95s]
10:22:24  15 of 26 START test assert_orders_have_users ................................... [RUN]
10:22:24  16 of 26 START test assert_username_normalized ................................. [RUN]
10:22:24  14 of 26 PASS assert_orders_after_user_birth ................................... [PASS in 1.22s]
10:22:24  17 of 26 START test assert_zip_matches_state ................................... [RUN]
10:22:24  13 of 26 PASS assert_birthdate_cleaning ........................................ [PASS in 1.42s]
10:22:24  18 of 26 START test not_null_stg_users_birthdate_is_valid ...................... [RUN]
10:22:25  16 of 26 PASS assert_username_normalized ....................................... [PASS in 0.78s]
10:22:25  19 of 26 START test not_null_stg_users_email ................................... [RUN]
10:22:25  15 of 26 PASS assert_orders_have_users ......................................... [PASS in 1.19s]
10:22:25  20 of 26 START test not_null_stg_users_state ................................... [RUN]
10:22:26  18 of 26 PASS not_null_stg_users_birthdate_is_valid ............................ [PASS in 1.03s]
10:22:26  21 of 26 START test not_null_stg_users_user_id ................................. [RUN]
10:22:26  17 of 26 WARN 43 assert_zip_matches_state ...................................... [WARN 43 in 1.44s]
10:22:26  22 of 26 START test not_null_stg_users_username_normalized ..................... [RUN]
10:22:26  19 of 26 PASS not_null_stg_users_email ......................................... [PASS in 0.91s]
10:22:26  23 of 26 START test relationships_stg_orders_user_id__user_id__ref_stg_users_ .. [RUN]
10:22:26  20 of 26 PASS not_null_stg_users_state ......................................... [PASS in 0.67s]
10:22:26  24 of 26 START test relationships_stg_users_state__code__ref_states_ ........... [RUN]
10:22:27  21 of 26 PASS not_null_stg_users_user_id ....................................... [PASS in 1.01s]
10:22:27  22 of 26 PASS not_null_stg_users_username_normalized ........................... [PASS in 0.87s]
10:22:27  25 of 26 START test unique_stg_users_email ..................................... [RUN]
10:22:27  26 of 26 START test unique_stg_users_user_id ................................... [RUN]
10:22:27  24 of 26 PASS relationships_stg_users_state__code__ref_states_ ................. [PASS in 0.73s]
10:22:27  23 of 26 PASS relationships_stg_orders_user_id__user_id__ref_stg_users_ ........ [PASS in 1.08s]
10:22:27  25 of 26 PASS unique_stg_users_email ........................................... [PASS in 0.42s]
10:22:27  26 of 26 PASS unique_stg_users_user_id ......................................... [PASS in 0.43s]
10:22:27
10:22:27  Finished running 24 data tests, 2 view models in 0 hours 0 minutes and 8.24 seconds (8.24s).
10:22:27
10:22:27  Completed with 1 warning:
10:22:27
10:22:27  [WARNING]: in test assert_zip_matches_state (tests/assert_zip_matches_state.sql)
10:22:27  [WARNING]: Got 43 results, configured to warn if != 0
10:22:27
10:22:27    compiled code at target/compiled/lab_medallion/tests/assert_zip_matches_state.sql
10:22:27
10:22:27    See test failures:
  -------------------------------------------------------------------------------
  select * from "lab_medallion"."main_dbt_test__audit"."assert_zip_matches_state"
  -------------------------------------------------------------------------------
10:22:27
10:22:27  Done. PASS=25 WARN=1 ERROR=0 SKIP=0 NO-OP=0 REUSED=0 TOTAL=26
