23 October 2018 · DataFreak ·       Add to Favorites   Report

How to change the system timezone in Snowflake?

You should be able to change the default timezone for the account with "ACCOUNTADMIN" role using an Alter account statement:

First, verify your present timezone:

show parameters like 'TIMEZONE%' in account;

Change the timezone:

alter account set timezone = 'Europe/Helsinki';

Verify if it is working:

show parameters like 'TIMEZONE%' in account;

DataFreak

posted on 23 October 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied