Skip to main content

Database Setup for Timezone Settings

In order to use our Timezone Settings, some special databases require an additional setup for timezone information.

Snowflake

Holistics needs to get the correct data source timezone of your Snowflake to apply the Timezone Settings feature:

  • Step 1: Log in to Snowflake Console using the same user at Holistics

  • Step 2: Run the query below to get the timezone for that user:

    SHOW PARAMETERS LIKE 'TIMEZONE%';

    The result will look like:

  • Step 3: Use the timezone in the value column to set the data source timezone at Holistics:

caution

Setting this value to anything other than the timezone that your database is in may lead to unexpected results.

MySQL

MySQL requires a timezone table to use the Timezone Settings feature. This can be run by an admin:

  • Step 1: Admins need to run the following command on your MySQL database server:

    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
  • Step 2: After that, try running some timezone-related queries to ensure the timezone table is loaded properly. For example:

    SET time_zone ='Asia/Singapore';

You might need to restart your MySQL server in order for the changes to take effect.

  • Step 3: Log in to Holistics and test the database connection: If you have connected to your MySQL before, you need to go to the Data Source Management > Edit data source > Re-test your connection:

For more information, you can read more in the MySQL documentation.

caution

In case the timezone information changes (i.e: your country decided to officially switch to a new timezone, excluded Day-light Saving Time), the applications that use the old rules become out of date and you need to reload the timezone tables to keep the timezone information up to date.






Let us know what you think about this document :)