Support for Cloud Provider Default Authentication Chains

[z0r0]

Describe the problem you are trying to solve
Different cloud providers have different priorities to how they resolve authentication metadata (mostly retrieving tokens). Having tremor honor those priorities helps users avoid risks around passing service account credentials in configuration files, or passing them as environment variables.

Describe the solution you'd like
For cloud provider specific connectors, it would be nice if tremor implemented the cloud provider best practices for implementing authentication. A first step might be implementing the default provider chain for S3. Google has a similar mechanisim, but unfortunately no rust support for it (yet)

Notes

If this is an implementation of an RFC provide a URL
to the RFC this enhancement implements.

If this is a major enhancement or contribution an RFC may be required. It is ok to submit an enhancement
first and our core team will assist with major contributions. In general, major contributions should be
discussed with the community before submission.