Snowflake user default time zone may require configuration to match Teradata value
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.
SET TIME ZONE USER;
/*** MSC-WARNING - MSCEWI2059 - SNOWFLAKE USER DEFAULT TIME ZONE MAY REQUIRE CONFIGURATION TO MATCH TERADATA VALUE ***/
ALTER SESSION UNSET TIMEZONE;
- Remember to set the default time zone of the user to a time zone equivalent to the one set for the Teradata user.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.