I am also having an issue getting dbt to run in production when it has no issue running locally. I a...

Daniel Lomartra

10/24/2023, 10:37 PM

I am also having an issue getting dbt to run in production when it has no issue running locally. I am using the new

.deploy()

method to create a docker image and push to an azure container registry then running my deployment from K8s. Seems to be some type of import error:

Copy code

PID 147 stream output:
[0m22:33:16  Finished running  in 0 hours 0 minutes and 0.31 seconds (0.31s).
[0m22:33:16  Encountered an error:
Runtime Error
  Database error while listing schemas in database "<OMITTED>"
  Database Error
    cannot import name 'SnowflakeOCSPAsn1Crypto' from 'snowflake.connector.ocsp_asn1crypto' (/usr/local/lib/python3.11/site-packages/snowflake/connector/ocsp_asn1crypto.py)

✅ 1

Sean Williams

10/24/2023, 10:47 PM

I believe there is an issue in a dependency of the snowflake connector. https://community.snowflake.com/s/question/0D5Do000010NAVzKAO/hi-snowflake-teami-am-faci[…]arynotfounderror-error-detecting-the-version-of-libcrypto

Sean Williams

10/24/2023, 10:47 PM

I've read that changing the version of it can help:

Copy code

pip install oscrypto@git+<https://github.com/wbond/oscrypto.git@d5f3437ed24257895ae1edd9e503cfb352e635a8>

but I haven't tried it

Daniel Lomartra

10/31/2023, 7:28 PM

Sorry for late response. This resolved it.

catjam 1

29 Views

Open in Slack

Previous Next

Prefect Community

Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.