Fixes #27014 Our cloud hosting requires using hard coded IAM auth for Athena. So make sure that if the access_key is left blank, we only fall back to the credential chain if we are not in a hosted environment.
