Error with assumed-role while trying to call a Lambda UDF from Redshift

0

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:---------------------------------------
  1. I am unable to figure out, since the IAM Role has all the necessary permissions for lambda.
  2. Also, please tell me what this arn:aws:stsmeans . I had never come this previously
AB
asked 4 months ago181 views
1 Answer
0
profile picture
EXPERT
answered 4 months ago
  • No. I had previously checked that website

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions