An admin is able to set their organization’s timezone via the Account page in their Admin Portal. By default, Sigma presents all data in UTC. Sigma’s custom account timezone feature allows Sigma administrators to present time-based data values in their organization's preferred timezone.
Summary of Content
- Only organization Admins can define an account timezone for their organization.
Select a Timezone
- Open your Admin Portal.
- Find the Timezone section on your Account page, and click Edit.
- Select a timezone from the dropdown menu.
- Click Save.
What to Expect
If you change the timezone (this is especially important for existing customers switching from UTC):
- Existing absolute date filters are not impacted by this change but will start showing the date range in the new timezone. For example, after switching from UTC to Americas/Los_Angeles, a static period originally defined as starting at 1/1/2021 0:00:00 will be presented as starting at 12/31/2020 15:00:00.
- Existing relative date filters defined in days or less granular units will be presented the same way (e.g. 30 days ago), but their meaning will change (e.g. from the midnight UTC 30 days ago to the midnight Pacific Time 30 days ago).
- Materialized datasets will keep using the old timezone until they are refreshed. If you are using materialized datasets, changing your account timezone may lead to temporary inconsistencies until all materializations are refreshed.
- Caution: Changing your timezone may impact how date values stored in timezone aware columns are interpreted. For example, if you insert “1/1/2021” into a Snowflake TIMESTAMP_TZ column using the UTC session timezone, Sigma will display it as 1/1/2021 00:00:00 if your organization timezone is set to UTC. However, if your timezone is Americas/Los_Angeles, the same timestamp will display as 12/31/2020 15:00:00.
Recommendation: don’t use timezone aware columns for storing date values.
- Caution: CSVs uploaded to Sigma automatically use a timezone aware column to store time and date values. If you have previously uploaded a CSV file with a date column, you should re-upload it after changing your organization’s timezone to prevent dates from being re-interpreted in the new timezone (see details in the previous bullet point).
- If a timestamp's source doesn't include information about the timezone, Sigma will automatically apply your account timezone (not UTC).