Currently (in at least BigQuery), using TIMESTAMP(${visitStartSeconds}) will trigger a double cast when you pick a non-UTC timezone since visitStart treats the datetime it receives from visitStartSeconds as a string. Adding an inline type-hint avoids this and gives the desired behavior.
This is also pointed out in the LookML documentation (thanks Olivia from DCL for finding it!).
cc: @ernestoongaro (since you seem to be the most active maintainer 😅)
Currently (in at least BigQuery), using
TIMESTAMP(${visitStartSeconds})will trigger a double cast when you pick a non-UTC timezone sincevisitStarttreats the datetime it receives fromvisitStartSecondsas a string. Adding an inline type-hint avoids this and gives the desired behavior.This is also pointed out in the LookML documentation (thanks Olivia from DCL for finding it!).
cc: @ernestoongaro (since you seem to be the most active maintainer 😅)