https://www.growthbook.io/ logo
#give-feedback
Title
# give-feedback
h

handsome-zebra-46141

08/31/2022, 1:01 PM
@future-teacher-7046 When defining a dimension column name in an Assignment Query GrowthBook should appropriately ‘quote’ the value.
An example of this is New vs Returning as a dimension.
I want the dimension to show up in the UI as ‘New vs Returning’ but if I set this as the column name in the SQL I need to quote it due to the spaces (so in BigQuery land
New vs Returning
). However, I then also need the quotes in column name I pass to GrowthBook otherwise I get a SQL error.
But that means the quotes show up in the UI!
Really GrowthBook should quote the dimension column names appropriately based on the DataWarehouse type it is connected to.
f

future-teacher-7046

08/31/2022, 1:09 PM
That sounds hard to do reliably across different SQL platforms and quoting styles. A couple solutions I can think of: 1. Strip all quote characters when displaying in the Dimension drop-down 2. Instead of a comma-separated list of dimension columns, make it a map from column name to display name. Then you could use a column like
new_vs_returning
and still have it display nicely in the UI
h

handsome-zebra-46141

08/31/2022, 1:12 PM
Instead of a comma-separated list of dimension columns, make it a map from column name to display name. Then you could use a column like
new_vs_returning
and still have it display nicely in the UI
This would probably be the easiest solution to maintain on the GrowthBook side
Strip all quote characters when displaying in the Dimension drop-down
Even this is probably more complicated than one might initially expect. There might be a deliberate trailing double quote for example?
15 Views