MSCEWI2059

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

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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]