I created a new strategy like said in the docs.
But my strategy uses other macros behind the scenes.
When executing, my strategy uses default macros to generate rows in my tables. For example, it uses defaut build_snapshot_table :
{% macro default__build_snapshot_table(strategy, sql) %}
select *,
{{ strategy.scd_id }} as dbt_scd_id,
{{ strategy.updated_at }} as dbt_updated_at,
{{ strategy.updated_at }} as dbt_valid_from,
nullif({{ strategy.updated_at }}, {{ strategy.updated_at }}) as dbt_valid_to
from (
{{ sql }}
) sbq
{% endmacro %}
But I want this behaviour in my custom strategy :
{% macro build_snapshot_table(strategy, sql) %}
select *,
{{ strategy.scd_id }} as dbt_scd_id,
{{ strategy.updated_at }} as dbt_updated_at,
{{ strategy.updated_at }} as dbt_valid_from,
to_TIMESTAMP('9999-12-31 23:59:59.999') as dbt_valid_to
from (
{{ sql }}
) sbq
{% endmacro %}
How to do this only for my strategy, and not all strategies ?