Add special character in dimension name

  • 24 January 2022
  • 1 reply

I need to add special  character in the dimension:  #_OF_IQ_SESSIONS { } but i am getting bellow error : 

“  Invalid field name "#_OF_IQ_SESSIONS". Field names may only include letters, numbers and underscores and must start with a letter or underscore for Google BigQuery Standard SQL.  “


So please suggest how to add special character with dimension name.


1 reply

My suggestion is to spell out the dimension, and then add a label with your special character instead:

   dimension: number_of_iq_sessions {
    label: "# of IQ Sessions”
    type: number