23 October 2018        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;

Read great educational content like this and a lot more ! Create my free account now 🎁