23 Oct 18 · DataFreak · #snowflake ·   Bookmark   ×

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 Oct 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds