Taragolis opened a new issue, #28000:
URL: https://github.com/apache/airflow/issues/28000

   ### Description
   
   Allow authenticating to Redshift Cluster in 
`airflow.providers.amazon.aws.hooks.redshift_sql.RedshiftSQLHook` with 
temporary IAM Credentials.
   
   This might be implemented by the same way as it already implemented into 
PostgreSQL Hook - manual obtain credentials by call 
[GetClusterCredentials](https://docs.aws.amazon.com/redshift/latest/APIReference/API_GetClusterCredentials.html)
 thought Redshift API.
   
   
https://github.com/apache/airflow/blob/56b5f3f4eed6a48180e9d15ba9bb9664656077b1/airflow/providers/postgres/hooks/postgres.py#L221-L235
   
   Or by passing obtained temporary credentials into 
[redshift-connector](https://github.com/aws/amazon-redshift-python-driver#example-using-iam-credentials)
   
   
   ### Use case/motivation
   
   This allows users connect to Redshift Cluster by re-use already existed 
[Amazon Web Services 
Connection](https://airflow.apache.org/docs/apache-airflow-providers-amazon/stable/connections/aws.html)
 
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to