I have a stored procedure in redshift and calling it by lambda function ...problem is with max time limit that is 15min for lambda function or that it give timeout error but our stored procedure require time more than that time to execute completly....so how to handle this issue. ..or any other way to call stored procedure in which no time limit will be there.

CodePudding user response：

It's difficult to say what exactly will work since your implementation and trigger details are not clear, but you would likely be able to to do this with AWS Step Functions instead of Lambda.

This blog post outlines a sample implementation using Step Functions and Redshift Data API - https://aws.amazon.com/blogs/big-data/etl-orchestration-using-the-amazon-redshift-data-api-and-aws-step-functions-with-aws-sdk-integration/

CodePudding user response：

There's no way you can bypass the time limit for the AWS lambda, you can use AWS Step Function to iterate multiple lambda calls, which it's very typical way to handle the tons of loads of lambda, but you will have a way to keep the state for the lambda calls