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

DBT test name: dbt_utils_expression_is_true_brazil_bol_2023_silver_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_silver

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_bdfec958d3fa2c96351e90c9f229b1fa") }}

select
    *
from "trase_production"."main_brazil"."brazil_bol_2023_silver"

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