[Feature] Adding Cloudwatch + stderr logs to dbt log using python models

[CommonCrisis]

Is this your first time submitting a feature request?

• I have searched the existing issues, and I could not find an existing issue for this feature

Describe the feature

We should stream the cloud watch logs created by the athena_user_logger and athena_shared_logger into the log file.

Right now it is annoying to always check the error in the AWS console.

Ideally we add the stderr output to the log as well by reading the output file in s3://<bucket_name>/<path>/session/<session_name>/stderr.

Describe alternatives you've considered

No response

Who will this benefit?

Everyone working with the python models

Are you interested in contributing this feature?

sure - can someone point to the logging logic?

Anything else?

No response