search

microsoft / dbt-fabric

MIT License
79 stars 28 forks source link

dbt test Incorrect syntax with macro helpers.sql - forgot square bracket on schema name #197

Closed SamuelNRS closed 4 months ago

SamuelNRS commented 5 months ago

I have a schema starting with a number as 10_TEXT. I'm trying to test with dbt-utils/unique_combination_of_columns. This test call one way or another macros/materializations/tests/helpers.sql. What causes my problem is the part of the code where the square brackets are forgotten : 

{% set testview %}
      {{ target.schema }}.testview_{{ range(1300, 19000) | random }}
{% endset %}

that should be

{% set testview %}
      [{{ target.schema }}].[testview_{{ range(1300, 19000) | random }}]
{% endset %}

dbt : 1.8.2 dbt-fabric : 1.8.6 dbt-labs/dbt_utils: 1.2.0 driver: ODBC Driver 18

in dbt_project.yml : 

quoting:
  database: true
  schema: true
  identifier: true