test dbt with Python 3.9

[gshank]

Hologram pull request dbt-labs/hologram#37 updates hologram to be compatible with Python 3.9. Update tox.ini with Python 3.9 targets and ensure that the test suite passes.

[jtcohen6]

If we determine that adding python 3.9 support is as simple as bumping the hologram dependency, we should release a new patch version (v0.18.2) that is compatible with py39, in addition to making v0.19.0 compatible. This will be a boon to users who cannot immediately upgrade to v0.19 because of breaking changes and deprecations.

[jtcohen6]

We won't be able to "officially" support python 3.9 for the core dbt distribution until snowflake-connector-python adds support for 3.9, by way of pyarrow: snowflakedb/snowflake-connector-python#562

As such, we won't be releasing a py39-compatible patch (v0.18.2). In the meantime, we'll make dbt-core work with python 3.9, and users of specific plugins will be able to pip install dbt-{adapter} within 3.9 environments. Hopefully it will just work, unless that plugin has other dependencies that are not yet compatible (as in the case of dbt-snowflake).

[MartinNowak]

As such, we won't be releasing a py39-compatible patch (v0.18.2). In the meantime, we'll make dbt-core work with python 3.9, and users of specific plugins will be able to pip install dbt-{adapter} within 3.9 environments. Hopefully it will just work, unless that plugin has other dependencies that are not yet compatible (as in the case of dbt-snowflake).

It seems that hologram wasn't updated as part of that v0.18.2 release, thus I'm still running into #2865 (duplicate of this issue) with Python 3.9.

The fix was merged with dbt-labs/hologram#34 and released with hologram==0.0.12, dbt==0.18.2 requires exactly hologram==0.0.10.

As a workaround I've been able to use dbt 0.18.2 with the newer hologram 0.0.14 for our dbt-bigquery use cases.

[jtcohen6]

@MartinNowak You're right, dbt v0.18.2 isn't compatible with python 3.9. We decided to focus instead on py39 compatibility in v0.19 (for dbt-core) and v0.20 (for all plugins included by pip install dbt). The only reason we ended up releasing v0.18.2 is because of a breaking change in the newest agate release (#3160).

[smitthakkar1]

Is dbt 0.20 compatible with Python 3.9.4 ?

[jtcohen6]

@smitthakkar1 Yes! Are you seeing any issues using the two together?

[smitthakkar1]

No, I just wanted to confirm before I go ahead with it. Thanks for answering my question. Thanks

…

On Thu, Jul 29, 2021, 5:58 PM Jeremy Cohen ***@***.***> wrote: @smitthakkar1 <https://github.com/smitthakkar1> Yes! Are you seeing any issues using the two together? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2822 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEH3T7AZ72WLF7KZBTKODZ3T2HFINANCNFSM4SI4TPCA> .