DBT Test: Dbt Utils Expression Is True Brazil Bol 2023 Gold Abs Net Weight Kg 1 0 Net Weight Tonnes 1000 5

DBT test name: dbt_utils_expression_is_true_brazil_bol_2023_gold_ABS_net_weight_kg_1_0_net_weight_tonnes_1000_5

DBT details

• Kind: generic (expression_is_true)

• Test file: trase/data_pipeline/models/brazil/trade/bol/_schema_brazil_bol.yml

• Original dbt_docs

---

Description

No description

---

Details

Depends OnTest codeCompiled code

Models

• brazil_bol_2023_gold

Macros

• test_expression_is_true
• get_where_subquery
• test_expression_is_true

{{ dbt_utils.test_expression_is_true(**_dbt_generic_test_kwargs) }}{{ config(alias="dbt_utils_expression_is_true_b_7b8e8651482fc675290a50ba06aa18ae") }}

select
    *
from "trase_production"."main_brazil"."brazil_bol_2023_gold"

where not(ABS((net_weight_kg * 1.0) - (net_weight_tonnes * 1000)) < 5)