SNOW-1776252: Prefer stdlib tzinfo objects over pytz's

[Kache]

What is the current behavior?

Uses pytz's tzinfo objects

The following queries:

SELECT TO_TIMESTAMP_TZ('2000-01-01 11:11:11+00:00')
SELECT TO_TIMESTAMP_TZ('2000-01-01 11:11:11+01:00')

Are returned by snowflake-connector and printed out (respectively) as:

datetime.datetime(2000, 1, 1, 11, 11, 11, tzinfo=<UTC>)
datetime.datetime(2000, 1, 1, 11, 11, 11, tzinfo=pytz.FixedOffset(60))

What is the desired behavior?

Use stdlib tzinfo objects

For example, if _generate_tzinfo_from_tzoffset() was changed like:

  def _generate_tzinfo_from_tzoffset(tzoffset_minutes: int) -> tzinfo:
      """Generates tzinfo object from tzoffset."""
-     return pytz.FixedOffset(tzoffset_minutes)
+     return dt.timezone(dt.timedelta(minutes=tzoffset_minutes))

then the previous examples would instead print out:

datetime.datetime(2000, 1, 1, 11, 11, 11, tzinfo=datetime.timezone.utc)
datetime.datetime(2000, 1, 1, 11, 11, 11, tzinfo=datetime.timezone(datetime.timedelta(seconds=3600)))

How would this improve snowflake-connector-python?

• the repr() of returned dt.datetime objects is valid Python (the <UTC> is not)
• removes a dependency in favor of stdlib

References and other background

worth considering: https://blog.ganssle.io/articles/2018/03/pytz-fastest-footgun.html

[sfc-gh-sghosh]

Hello @Kache ,

Thanks for raising the request; we will review it internally and get back to you.

Regards,
Sujan

[sfc-gh-sghosh]

Hello @Kache ,

The team is working and looking into it, there is no ETA as of now.

Regards,
Sujan

[sfc-gh-sghosh]

Hello @Kache ,

Do you have an account in Snowflake? could you let us know?

Regards,
Sujan

[sfc-gh-sghosh]

Hello @Kache ,

Do you have an account in Snowflake? could you let us know?

Regards,
Sujan

[Kache]

I'm using my employer's account

[sfc-gh-sghosh]

Hi kache,

Thanks for the update, whats the name of your employer? do they have aan ccount in Snowflake?
You can raise an official support ticket to share above details.
https://community.snowflake.com/s/article/How-To-Submit-a-Support-Case-in-Snowflake-Lodge

[Kache]

Sure, I'll do that

update I've opened support case 00918876