23 Oct 18 · DataFreak ·       Add to Favorites  

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

Copied