Anybody else get this certs error on the target-snowflake?

We are seeing

sqlalchemy.exc.OperationalError: (snowflake.connector.errors.OperationalError) 254007: 254007: The certificate is revoked or could not be validated: hostname=<http://sfc-eu-ds1-customer-stage.s3.amazonaws.com|sfc-eu-ds1-customer-stage.s3.amazonaws.com>

Still looking for a fix.

fork; tie version seems to be working

Thanks. So this

certifi

version breaks it? https://pypi.org/project/certifi/2025.4.26/

saw docs to tie to pip install certifi==2025.1.31

Curious where you saw this? I found https://github.com/certifi/python-certifi/issues/349

full story is here: https://status.snowflake.com/

Quickest fix was to include

certifi==2025.1.31

in the

pip_url

for

target-snowflake

. Otherwise this is also patched in version 0.6.13 of the target. Thanks both!

Yeah, ended up doing that. Thanks @Edgar Ramírez (Arch.dev)

That worked for us as well, thank you so much!