Simplify setting credentials when switching between different environments

[ElenaKhaustova]

Description

Accessing credentials and setting them for different environments is not simple. Users have to define separate catalog entries for different environments to be able to switch between them. They expect to define one catalog entry per credential or/and some guidance on how to make it simpler for such cases.

We propose to:

1. Explore the feasibility of such a request.
2. Check if it is possible to simplify switching between environments with the existing credential configuration options and update documentation with the relevant examples.

Relates to https://github.com/kedro-org/kedro/issues/3811

Context

When running on local they had credentials.yml with a password but when running on AWS Glue they had to use this method to access the same credentials.