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.
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" ;;
}