there’s multiple data types available in snowflake - Timestamp_tz, timestamp_ntz.
when we use dimension group function in lookML (time type), and I bring out a filter using dimension group field, for example, we want data after 2020.01.01, LOOKER will generate TIMESTAMP_TZ in the query rather than timestamp_ntz. and I didn’t find any way to control this... (I tried including convert_tz in look ML in that group dimension but it didn’t work)
basically it will generate a query like this.
EXTRACT('EPOCH', CAST(TO_TIMESTAMP('2020-01-01') AS TIMESTAMP_TZ))
I want it to be:
EXTRACT('EPOCH', CAST(TO_TIMESTAMP('2020-01-01') AS TIMESTAMP_NTZ))
So is there any way to let it generate TIMESTAMP_NTZ? If it’s not, the outcome from snowflake and Looker will be not consistent when we include a comparison logic in where clause. Thank you!