Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
SamuelNRS opened this issue Jun 24, 2024 · 0 comments

Comments

@SamuelNRS
Copy link

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 
prdpsvs added a commit that referenced this issue Jun 27, 2024
prdpsvs added a commit that referenced this issue Jun 27, 2024
Addressing issues 189, 188, 181, 179, #197
@prdpsvs prdpsvs closed this as completed Jun 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants