The data dictionary table SystemTimezones contains definitions of timezones and their daylight saving time periods for time periods.
For each named timezone like ‘Europe/Amsterdam’ there can be multiple rows, each one describing the settings for a UTC time period.
To find all timezone definitions for Amsterdam:
select *
from systemtimezones@datadictionary
where name = 'Europe/Amsterdam'
The result is:
Availability
The new SystemTimezones table will be available starting release 24.0.6.