Oksana Gorbachenko
11/09/2023, 11:41 PM- name: vacation_policy_assigned
description: "{{ doc('vacation_policy_assigned') }}"
tests:
- dbt_expectations.expect_column_to_exist
- dbt_expectations.expect_column_values_to_be_of_type:
column_type: varchar
- expect_column_values_to_match_regex:
select_columns: "employee_id, vacation_policy_assigned"
regex: "^[a-zA-Z0-9.,]+$"Dmitry Darkin
11/10/2023, 12:28 AMNoa Kurman
12/06/2023, 12:24 PMOksana Gorbachenko
12/06/2023, 12:31 PM0.12.1 works fine for us, thanks a lot!Anna Vasileva
01/22/2024, 7:07 AM0.13.2 and faced the same problem.Constantino Schillebeeckx
01/29/2024, 6:29 PM0.9.2 (and cannot, unfortunately, upgrade)Constantino Schillebeeckx
01/29/2024, 6:43 PMAnna Vasileva
01/30/2024, 6:23 AMon-run-end hook will run in parallel as well. This hook collects and saves artifact data. Duplication in the artifact tables will cause this issue (the query of getting the test results includes a join with the artifact table).
example: elementary_test_results 1 record * dbt_sources 2 records * dbt_tests 6 records -> 12 records in the reportLuis Oliveira
04/16/2024, 1:31 PMNoa Kurman
04/16/2024, 1:35 PMLuis Oliveira
04/16/2024, 1:39 PMAnna Vasileva
04/16/2024, 1:44 PMAnna Vasileva
04/16/2024, 1:47 PMdbt run --select elementary, this does not delete important data, but gets rid of duplicates.Luis Oliveira
04/16/2024, 1:47 PMLuis Oliveira
04/16/2024, 2:08 PMAnna Vasileva
04/16/2024, 2:12 PMAnna Vasileva
04/16/2024, 2:13 PMClaire Taylor
05/08/2024, 7:19 AMdisable_dbt_artifacts_autoupload: true in our elementary runs and just run the artifact upload at deploy time, is it likely to fix it? (We do run multiple dbt commands at the same time, so seems like it could be the same problem)