A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
When using the stage macro, if hashed columns have the same name as a source column, a DUPLICATE COLUMN SQL error will be raised.
The expected behaviour is that the hashed_column definition will take precedence over the original source column, and the source column will not be present in the final stage table.
Additionally, if include_source_columns = true and a derived_columnis defined which derives its value from a source column, then the source column will not be included in the final stage layer.
The expected behaviour is that both the original column and the new aliased column will be present in the final stage layer.
DUPLICATE COLUMNSQL error will be raised.The expected behaviour is that the
hashed_columndefinition will take precedence over the original source column, and the source column will not be present in the final stage table.include_source_columns = trueand aderived_columnis defined which derives its value from a source column, then the source column will not be included in the final stage layer.The expected behaviour is that both the original column and the new aliased column will be present in the final stage layer.
We plan to fix this for the next release.