[BUG] Hash Datatype should be adapter specific

ScalefreeCOM / datavault4dbt

Scalefree's dbt package for a Data Vault 2.0 implementation congruent to the original Data Vault 2.0 definition by Dan Linstedt including the Staging Area, DV2.0 main entities, PITs and Snapshot Tables.

https://www.scalefree.com/

Apache License 2.0

141 stars 27 forks source link

[BUG] Hash Datatype should be adapter specific #288

Open tkirschke opened 3 hours ago

tkirschke commented 3 hours ago

Describe the bug

The global variable "datavault4dbt.hash_datatype" is set to "STRING" by default. In Fabric, STRING does not exist. Hence, it should be a dictionary with adapter specific values, similar to other global variables.

Environment

dbt version: Cloud
datavault4dbt version: 1.8.0
Database/Platform: Microsoft Fabric

tkirschke commented 3 hours ago

VARCHAR(34) could be used as a default for Fabric