Amazon Aurora MySQL - Trigger to invoke AWS Lambda

trigger.sql

DROP TRIGGER IF EXISTS TR_contacts_on_insert;
DELIMITER ;;
CREATE TRIGGER TR_contacts_on_insert
  AFTER INSERT ON Contacts
  FOR EACH ROW
BEGIN
  SELECT  NEW.email , NEW.fullname
  INTO @Email , @Fullname;
  lambda_async(
    'arn:aws:lambda:REGION:ACCOUNT_ID:function:SendEmailWithContact', 
    CONCAT('{ "email" : "', Email, '", "fullname" : "', FullName, '"}')
  );
END
;;
DELIMITER ;

hey dude, did you face an error like that? Lambda API returned an error: Missing IAM Credentials for specified aws_default_lambda_role I'm stuck on this error :(

@wakeupmh Did you find the solution? I think Giving Aurora access to Lambda will help. aws_default_lambda_role is mentioned in step 3.
Also make sure you granted AWS_LAMBDA_ACCESS role to the DB user. See details from here