Dimension does not execute in explore

[mohiit_jain3]

I have:

dimension: fl {
    type: string
    sql: CONCAT('flt-', ${departure_date}, '_' , ${oa.iata}, '-', ${da.iata}) ;;
    }

  dimension_group: departure {
    type: time
    timeframes: [
      raw,
      time,
      date,
      week,
      month,
      quarter,
      year
    ]
    sql: TIMESTAMP (${TABLE}.departure_at, “UTC”) ;;
  }

But its throwing this error in Looker when I am creating a dashboard in an explore--

 

The Google BigQuery Standard SQL database encountered an error while running this query.

Query execution failed: - Syntax error: Illegal input character "\342" at [2:56]

SELECT    CONCAT('flt-', (DATE(TIMESTAMP (legs.departure_at, “UTC”) , 'America/Los_Angeles')), '_' , oa.iata, '-', da.iata)  AS fl

However, this perfectly works when I run this as a sql query. I don’t understand the reason why? can anyone please help?

[mohiit_jain3]

anyone?

[Dawid]

 “UTC” try changing it to ‘UTC’

Alternatively, read about this zero-widh-joiner: https://stackoverflow.com/questions/20420890/getting-errors-stray-342-and-200-and-214

[mohiit_jain3]

I just cracked and about to put the comment here, this worked @Dawid . thank you so much!