I am trying to use an UDF Function in Redshift. and the IAM Role associated with it has "lambda:InvokeFunction"
on all resource enabled.
However, when I tried to run the query :-
SELECT f_udf_func(person_name, 'A') FROM "users"."tbl_user_detl";
However, I am getting the following error :-
ERROR: User: arn:aws:sts:<account-id>:assumed-role/redsift-exec-role/RedshiftIamRoleSession is not authorised to perform : lambda:InvokeFunction on resource <lambda_arn> bec Detail:---------------------------------------
- I am unable to figure out, since the IAM Role has all the necessary permissions for lambda.
- Also, please tell me what this
arn:aws:sts
means . I had never come this previously
No. I had previously checked that website