We are seeing this error when attempting to apply dimensions to an analysis

function concat(character varying, "unknown", character varying) does not exist

this is in redshift The issue appears to be this clause:

REGEXP_REPLACE(
        MIN(
          CONCAT(
            cast(e.timestamp as varchar),
            '____',
            coalesce(cast(e.dimension as varchar), '__NULL_DIMENSION')
          )
        ),
        '.*____',
        ''
      ) as dimension,

I believe the

'____'

also needs to be wrapped in a cast() function Self-hosting: Build: f58a91e (2023-03-31)

We fixed this bug last week in https://github.com/growthbook/growthbook/pull/1184

excellent, didn’t see that in my quick scan. I will update our build.

We had been testing queries on Postgres, assuming Redshift would behave similarly. We've since added Redshift to our testing infrastructure, so hopefully we can catch these types of errors before they go live in the future.

yup, makes sense, much of the time postgres is sufficient.