<@U01TCPDB58C> When defining a dimension column na...
# give-feedbackh
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.
handsome-zebra-46141
08/31/2022, 1:01 PMAn example of this is New vs Returning as a dimension.
handsome-zebra-46141
08/31/2022, 1:03 PMI 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 Returninghandsome-zebra-46141
08/31/2022, 1:03 PMBut that means the quotes show up in the UI!
handsome-zebra-46141
08/31/2022, 1:04 PMReally 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_returningh
handsome-zebra-46141
08/31/2022, 1:12 PMInstead of a comma-separated list of dimension columns, make it a map from column name to display name. Then you could use a column likeThis would probably be the easiest solution to maintain on the GrowthBook sideand still have it display nicely in the UInew_vs_returning
handsome-zebra-46141
08/31/2022, 1:13 PMStrip all quote characters when displaying in the Dimension drop-downEven this is probably more complicated than one might initially expect. There might be a deliberate trailing double quote for example?
67 Views