MSCEWI2059

Snowflake user default time zone may require configuration to match Teradata value

Severity
Low
Description
Same as Teradata, setting a default time zone value to the user will make sessions start using that time zone until a new value is defined for the session.
This warning is generated to remind that the same time zone that was defined for the user in Teradata should be set for the Snowflake user, to do this please use the following query in Snowflake: ALTER SESSION SET TIMEZONE = 'equivalent_timezone', remember that Snowflake only accepts IANA Time Zone Database standard time zones.
Example Code
Input Code:
SET TIME ZONE USER;
Output Code:
/*** MSC-WARNING - MSCEWI2059 - SNOWFLAKE USER DEFAULT TIME ZONE MAY REQUIRE CONFIGURATION TO MATCH TERADATA VALUE ***/
ALTER SESSION UNSET TIMEZONE;
Recommendations
Remember to set the default time zone of the user to a time zone equivalent to the one set for the Teradata user.
If you need more support, you can email us at [email protected]​

MSCEWI2058

MSCEWI2060

Last modified 3mo ago