Hello, I am having trouble with the dimension_anom...
# community-support
a
Hello, I am having trouble with the dimension_anomalies test. I have a SQL compilation error when executing the command dbt test -s test_elementary -t prod (where test_elementary is the name of the model):
Copy code
syntax error line 11 at position 287 unexpected '_'
I can't find where the wrong SQL code is generated. I am using Snowflake.
โœ… 1
n
Hey @Arnaud Ferrer ๐Ÿ‘‹๐Ÿผ Can you please share which package version are you using, the model code, the test configuration, and the full log file? ๐Ÿ™๐Ÿผ
a
Hello Noy, I've just tried another test and it works. So I have investigated deeper and I made a mistake in the syntax of the test. I was writing the name of the column to test directly after the
dimensions
parameter instead of writing this column as a list, like this:
Copy code
dimensions : "app_api_key"
instead of โคต๏ธ
Copy code
dimensions : 
  - app_api_key
Sorry to ask for help for such a mistake.
n
No worries, happy you were able to make it work ๐Ÿ’ซ