Add special character in dimension name

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.

0 1 496
1 REPLY 1

lindenPMP
Participant II

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
    sql: ${TABLE}."NUMBER_OF_IQ_SESSIONS" ;;
  }
Top Labels in this Space
Top Solution Authors