Add special character in dimension name

  • 24 January 2022
  • 1 reply
  • 88 views

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.

 


This topic has been closed for comments

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
    sql: ${TABLE}."NUMBER_OF_IQ_SESSIONS" ;;
  }