Hey :wave: Could someone help me with the error I ...
# ask-questions
Hey 👋 Could someone help me with the error I get when applying dimensions to my experiment results? So I’m using Amazon Redshift and apparently it encounters error with concat function, which is used in Growthbook’s query.
Copy code
      cast(e.timestamp as varchar),
      coalesce(cast(e.dimension as varchar), '__NULL_DIMENSION')
) as dimension,
Hey @fresh-football-47124 is there a way to fix it? This query was generated by Growthbook and I have no power over it. I get the same error when running it in IDE. Just to give more context, I’ve declared session_marketing_source dimension in assignment query and it throws error when applying this dimension to the experiment results. There’s a same topic in Github: https://github.com/metabase/metabase/issues/12544
We’re working on a fix
Great news, thank you very much! If you have an ETA for it, I’d be glad to know
Also @fresh-football-47124 I’m not sure why, but this is only applicable to dimensions that were specified in assignment query. Dimensions from ‘Dimensions’ tab seem to work
Hi Katerina. This is a problem on redshift with some special handling we added to use the first dimension value per user as part of our SQL refactor. This "first" notion only applies to assignment query dimensions (which have a timestamp) and not user dimensions (which do not have a timestamp; for those we just use the MAX dimension and instead ask users to only have a 1:1 user to dimension mapping). So we need to fix this logic for the assignment query dimensions and we know how to do so. Just give us a second to test it.
As for an ETA, we should land a fix tomorrow pacific time.
Hey Luke, thanks a lot for explaining 🙌
Hey Katerina! Can you let us know if the fix we landed on Friday worked for you?
Hey Luke, I’ve checked and it works, thank you!
🙌 1