Snowflake and Looker Date Transfer Issue (snowflake time zone related) - about timestamp_ntz

[yilin_liu]

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!