Cannot import name 'SnowflakeOCSPAsn1Crypto' from partially initialized module occurs when running `dbt test`

Archive
1

I was just trying a small dbt sample project with dbt 0.20.1 against my Snowflake db to test a bug that exists in 0.19 and I run into the following error when I try to run dbt test. Workaround seems to be reducing the thread number to 1 in profiles.yml.

Encountered an error:
Runtime Error
  cannot import name 'SnowflakeOCSPAsn1Crypto' from partially initialized module 'snowflake.connector.ocsp_asn1crypto' (most likely due to a circular import) (/Users/mfuruya/src/dbt-config-bug/materialization_test_run_bug/dbt-env/lib/python3.9/site-packages/snowflake/connector/ocsp_asn1crypto.py)

Related Slack thread

Is it something wrong my machine or is this a bug?

2

Was there any resolution to this, besides lowering thread count to 1?

I am currently seeing the same issue using:
dbt-snowflake==1.0.0
snowflake-connector-python==2.7.3

3

I was getting the same error on a model where I had a commented out some config…my best guess is that the interpreter was still attempting to interpolate the Jinja and this was somehow causing the circular dependency

The offending comment:

-- {{ config(materialized = 'ephemeral') }}