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.

Prefect Community

Hello, has anyone run into the below errors while using DbtShellTask?

```[33mHTTPSConnectionPool(host='<http://bigquery.googleapis.com|bigquery.googleapis.com>', port=443): Max retries exceeded with url: /bigquery/v2/projects/xxx/datasets/gsheets/tables/stocks_data?prettyPrint=false (Caused by SSLError(SSLError("bad handshake: SysCallError(-1, 'Unexpected EOF')")))[0m```

```[33m('Connection aborted.', OSError("(32, 'EPIPE')"))[0m```

These errors are from running a DbtShellTask in a Prefect flow on a Ubuntu 20.04 server

Running `dbt run`  on the same server and dbt runs without such errors - doesn't seem to be any firewall / network issues

Hey <@U01AYG8QZ4Y>, hard to say but a couple of suggestions
• Are you maybe using <https://stackoverflow.com/questions/65129534/bigquery-max-retries-exceeded-when-running-dbt|preemptible compute resources> anywhere?
• Are you running this job on a different machine? 
• You can also try <https://stackoverflow.com/a/47294770/11163214|downgrading the requests library>
• You likely have to load your certificate to Python for the request library like this. <https://stackoverflow.com/questions/42982143/python-requests-how-to-use-system-ca-certificates-debian-ubuntu/42982144|Linux>, <https://stackoverflow.com/questions/40684543/how-to-make-python-use-ca-certificates-from-mac-os-truststore|Mac>

Thanks <@U01QEJ9PP53>, this was very helpful - downgrading my requests library solved the issue