datavault4dbt icon indicating copy to clipboard operation
datavault4dbt copied to clipboard

Improvement of NH Link performance on Snowflake

Open tkirschke opened this issue 1 year ago • 2 comments

The loading of a NH Link can be improved by skipping a full table scan while using the High Water Mark:

image image

tkirschke avatar Feb 05 '24 12:02 tkirschke

And one additional suggestion to improve the speed for the sat_v0 macro: image

This reduces the amount of data of the sat table that is needed to join from the stage.

VSchmidts avatar Feb 13 '24 10:02 VSchmidts

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

github-actions[bot] avatar Jul 08 '24 06:07 github-actions[bot]