[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1002)

[May1234]

When running spectacles command with Cloudflare WARP turning on, I am getting SSL certificate error. Can someone please give some advice?

spectacles sql --config-file configs/config.yaml --project abc

Connected to Looker version 24.14.35 using Looker API 4.0
Completed SQL validation in .

Encountered unexpected SSLCertVerificationError: "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1002)"
Full error traceback logged to file.

For support, please create an issue at https://github.com/spectacles-ci/spectacles/issues

[DylanBaker]

Hi @May1234. Could you confirm that when you don't have Cloudflare WARP on that this works as expected?

I expect there's something incorrect in the SSL certificate in the setup. I believe you would either need to remedy that issue or fork Spectacles to turn off SSL verification.

[May1234]

Hi @DylanBaker, thanks for the reply.
There is no issue when turning off CloudFlare WARP. I tried many ways to resolve the problem, but all failed.
Since I thought Spectacles is python utility, I tried this way as well, but it didn't work.
https://developers.cloudflare.com/cloudflare-one/connections/connect-devices/warp/user-side-certificates/install-cloudflare-cert/#python