Followed this tutorial: https://docs.aws.amazon.com/glue/latest/ug/tutorial-elastisearch-connector.html
I know using this connector can connect to Aws Elasticsearch, but this still needs AWS Secrets Manager to store the username and password.
Is it possible to use IAM authentication to connect to Elasticsearch, rather than username & password?
is it possible to use IAM authentication
No, unfortunately.
The Elasticsearch Connector for AWS Glue does not currently support IAM authentication & only supports username and password as an authentication mechanism.