Snowflake infers from the date provided whether to use a 4 hour offset or 5 hour offset for 'America/New_York' timezone. If you pass a datetime that occurs during non-DST period, it will be -5 hours from UTC. If you pass a datetime that occurs during DST, it will be -4 hours.