Re-submit #286 to fix credential handling for use_interactive_session_role_for_api_calls

[moomindani]

In # 319, We needed to revert multiple PRs including #286. This PR is to re-submit PR #286 to fix credential handling for use_interactive_session_role_for_api_calls.

Description

The CreateDabase operation is performed with the caller role. We want it to be performed by the glue session role_arn provided in profiles.yml.

Important note: There is a difference from #286. This PR does not change default value for use_interactive_session_role_for_api_calls parameter.

Checklist

• [x] I have signed the CLA
• [x] I have run this code in development and it appears to resolve the stated issue
• [x] This PR includes tests, or tests are not required/relevant for this PR
• [ ] I have updated the CHANGELOG.md and added information about my change to the "dbt-glue next" section.

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.