Avoid TO_DATE casting when data type already is DATE

This is the LookML

  dimension_group: dt {
type: time
timeframes: [
date,
month,
quarter,
year
]
convert_tz: no
datatype: date
sql: ${TABLE}."DT" ;;
}

and this is the generated SQL when including date

SELECT
(TO_CHAR(TO_DATE(datamart."DT" ), 'YYYY-MM-DD')) AS "datamart.dt_date",

The DT column in the database table is of data type DATE, so why does Looker generate TO_DATE and is it possible to get it to not do that?

0 0 125
0 REPLIES 0
Top Labels in this Space
Top Solution Authors