Recalculate HDiff in BV-Satellite

[lorogno]

Hey!
we have currently developed a BV-Satellite based on a RV-Satellite where we derive new columns based on business rules. We would like to recalculate the Hashdiff in the BV-Satellite to track the History correct afterwards in Marts.

Is there any standard-approach / experiences to recalculate the hashdiff for all BV-Satellite columns in a datavault4dbt-way? We would like to avoid hashing it not in the same way as the standardized-hashing within dv4dbt :)

[tkirschke]

Hi @lorogno and thanks for reaching out!

You can always call the datavault4dbt hash macros to hash whatever you want wherever you want.

In an example business satellite this could look the following:

{%- set hash_config_yaml -%}
hd_customer_bs:
    is_hashdiff: true
    columns:
      - original_col_1
      - original_col_2
      - calculated_col_1
      - calculated_col_2
{%- endset -%}

{% set hash_config_dict = fromyaml(hash_config_yaml) %}

WITH 

calculations as (
    SELECT
        hk_customer_h,
        ldts,
        original_col_1,
        original_col_2,
        (original_col_1 + original_col_2) as calculated_col_1,
        (original_col_1 / original_col_2) as calculated_col_2
    FROM {{ ref('Customer_n_s') }}
)
SELECT
    *,
    {{ datavault4dbt.hash_columns(columns=hash_config_dict) }}
FROM calculations 

Hope this helps!