Open tkirschke opened 1 year ago
COALESCE(MAX({{ src_ldts }}),{{ datavault4dbt.string_to_timestamp(timestamp_format, beginning_of_all_times) }})
This issue is stale because it has been open for 90 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue. Otherwise it will be closed in 14 days
check all macros and apply this to all that use a HWM
In All Kinds of Satellites there is a HWM logic applied for incremental runs. This logic checks
WHERE ldts > (SELECT max(ldts) FROM {{ this }})
But for cases, where this table is truncated outside of dbt,
SELECT max(ldts)
would returnNULL
, and on some databases the comparisonldts > NULL
throws an error.To avoid this, we need to insert the beginning-of-all-times for cases when
max(ldts)
returnsNULL
, like this:WHERE ldts > (SELECT COALESCE(max(ldts), {{ datavault4dbt.beginning_of_all_times() }}) FROM {{ this }})
Thanks to
for pointing out this issue and proposing a solution!