Issue:
I am leveraging Query Time Zone connection settings and my ‘Date’ dimension is being converted twice. Has anyone else encountered this? See below for details.
Connection Settings:
My time zone connection settings are set as follows:
Database Time Zone: UTC
Query Time Zone: US Eastern (America - New York)
My Date Dimension is set up as follows: (Note, I am purposely not using a dimension_group)
dimension: placed_date {
type: date
sql: ${created_datetime_date} ;;
label: "Date"
group_label: " Order Date Placed"
}
The Looker SQL for ‘Date’ when running a basic query is ad foilows:
(DATE(CONVERT_TIMEZONE('UTC', 'America/New_York', (DATE(CONVERT_TIMEZONE('UTC', 'America/New_York', created_datetime ))) ))) AS "date",
Anyone know why Looker has the convert_timezone, wrapped in another convert_timezone? Want to confirm I am missing something.