Enhanced Logging into AWS Redshift

[sandeepsehrawat]

HI team

We are planning to run Data Lineage tool against AWS Redshift to generate column level lineage.
In the demo we can see that the only option to connect to source database is by using username and password which is not inline with our security policy hence raising this request here for any options like tokens of AWS KMS that we can use to login to AWS redshift without using username and password in python code.

Also is there any option where we do NOT login to source database and generate lineage from the queries file ,like can we download the DDL and tool uses that DDL for query parsing rather than using an active connection to the source database.

Appreciate your response on this and please let me know if more information is required on this.