Snowflake has a data type called TIMESTAMP_TZ, which stores timestamps in UTC alongside a timezone offset. When querying this datatype in Omni, this data type lead to confusion and seemingly inconsistent behavior when querying and filtering data on the margins of dates.
We recommend converting out of this data type in Omni by casting to the TIMESTAMP_LTZ data type. This will store the timestamp field in UTC, and then Omni’s timezone settings will be applied to give you more control. Read more about TIMESTAMP_LTZ in Snowflake’s documentation.