v1.1.4
Pre-release
ATTENTION! IMPORTANT DISCLAIMER FOR v1.1.4
There is a fix for the hashing algorithm in the Snowflake adapter that will generate different hash for columns with strings containing the small character 'v' . The reason behind this is that Snowflake doesnt interpret the \v as a special character alias for the vertical tab, so instead it interprets that you are escaping the letter v. The issue was first presented at #109
This fix means if you have a BK with value 'virtual', for example, in version 1.1.3 or earlier versions the hash algorithm was actually removing the small character 'v', so the value to be hashed was 'irtual' (which is wrong), the value to be hashed should be 'virtual', in PR #118 we fix the hash so that it will now hash the correct value.
Therefore, if this key comes into the stage it will be hashed and generate a different hash value than the one encountered previously loaded in your Raw Vault. This hashkey will then be inserted into you Raw Vault, even though it represents the same BK, because it was not inserted before.
We strongly recommend that the user manually modifies the hashes which include this small character in the Raw Vault, updating the value to the correct one generated by the hash algorithm in this presented version, so that your stage wont falsely detect "new" keys.
We deeply apologize for the inconvenience that this generates.
Kind regards,
Your Scalefree datavault4dbt team.
What's Changed
All adapters - new feature and fix:
- Extended logarithmic logic of snapshot control tables by @bschlottfeldt in #116
- Fixed sat_v0 : Same hashdiff being inserted again into satellite without in between deltas by @bschlottfeldt in #123
Snowflake adapter - fix and new feature:
- Fixed replacement of vertical tab in hash_standardization - Snowflake adapter by @thoffmann-sf in #118
- Added RTRIM Hashdiff Option for Snowflake by @bschlottfeldt in #119 - More information on how to use this new feature can be found in https://github.com/ScalefreeCOM/datavault4dbt/wiki/Adding-new-columns-to-Hashdiff-and-Satellite
New Contributors
- @thoffmann-sf made their first contribution in #118
Full Changelog: v1.1.3...v1.1.4
