SSC-EWI-TD0059

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:

IN -> Teradata_01.sql

SET TIME ZONE USER;

Output Code:

OUT -> Teradata_01.sql

!!!RESOLVE EWI!!! /*** SSC-EWI-TD0059 - 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 [e-mail]