https://www.growthbook.io/
Join Slack
<@U01TCPDB58C> When defining a dimension column name in an Assignment Query GrowthBook should approp...
# give-feedback
h
@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
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
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?
75 Views
Open in Slack
PreviousNext
Powered by

GrowthBook Users

Open source platform for stress free deployments, measured impact, and smarter decisions.

Powered by