When defining a dimension column name

Question

< future teacher 7046> When defining a dimension column name in an Assignment Query GrowthBook should appropriately quote the value

handsome-zebra-46141 · Answer

An example of this is New vs Returning as a dimension

handsome-zebra-46141 · Answer

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

handsome-zebra-46141 · Answer

But that means the quotes show up in the UI

handsome-zebra-46141 · Answer

Really GrowthBook should quote the dimension column names appropriately based on the DataWarehouse type it is connected to

future-teacher-7046 · Answer

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

handsome-zebra-46141 · Answer

gt 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

handsome-zebra-46141 · Answer

gt 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