Montreal-Analytics / dbt-snowflake-utils

Snowflake-specific utility macros for dbt projects.
Apache License 2.0
105 stars 36 forks source link

fix: correct cache key #54

Closed calleo closed 8 months ago

calleo commented 9 months ago

This package uses a cache to check if a tag exists or if it needs to be created. Once a tag is created it is added to the cache. This did not work properly, since the different keys were used at cache lookup (tag name) and add to cache (fully qualified tag name).

I noticed this in a DBT project where multiple models, in the same schema, are creating table tags independently of each other. If the first model creates the tag, the next model would also try to create it leading to this error:

09:23:58 Tag already exists: GOLD.DBT_CV_DEV_VALIDATIONS.DBT_VALIDATION_KEY