search

Datavault-UK / automate-dv

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)
https://www.automate-dv.com
Apache License 2.0
511 stars 131 forks source link

[BUG] unbalanced parenthesis at position 13 when switching from dbtvault 0.9.0 to 0.9.1 or higher #193

Closed RonniePitts closed 1 year ago

RonniePitts commented 1 year ago

This isn't a bug but a misconfiguration issue that causes parsing model errors when moving from dbtvault >=0.9.1.

dbtvault.stage macro will return "unbalanced parenthesis at position 13" if the escape_char_left configured within the dbt_project.yml is blank, for example:

`

Defining variables

vars: escape_char_left: '' escape_char_right: '' `

RonniePitts commented 1 year ago

Solution, remove the blank escape_char_left and escape_char_right from the dbt_porject.yml

DVTimWilson commented 1 year ago

Solution, remove the blank escape_char_left and escape_char_right from the dbt_porject.yml

Hi Ron, glad that you have resolved this, we shall improve the code to trap this situation, and also review and update the documentation to clarify the usage, thanks.

DVTimWilson commented 1 year ago

Issue added to internal development backlog.