TST: Fix local run on s3 tests
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit) for how to run them

xref https://github.com/pandas-dev/pandas/pull/44612#issuecomment-984548056

cc @simonjayhawkins I ran this locally on some test and it was working. Let me know if this works for you as well

thanks @mroeschke  > cc @simonjayhawkins I ran this locally on some test and it was working. Let me know if this works for you as well

All good now. Thanks @mroeschke 