I have a question regarding dimension_anomalies It should be possible to use a sql expression for the dimensions, so my config is as follows

tests:
      - elementary.dimension_anomalies:
          tags: ["elementary_new"]
          dimensions:
            - "TO_VARCHAR(SPLIT(TO_VARCHAR(event_params_array:page_location), '?')[0])"

The run results in following error

SQL compilation error:
  syntax error line 148 at position 78 unexpected '?'.

Even though it is a valid expression. Anyone with an idea on that?

Hey @FelixJ, 1. Have you tried without the quotes ? 2. What is

event_params_array:page_location

exactly ?

Hi @Daniel Pollak yes, I've also tried it wihtout quotes, same result. Event_Params_Array is a variant field in Snowflake. Inside the Variant is an Object with Key-Value pairs. The referred "page_location" is the key and the respecting value is a usual string