Can we get user inputs for lambda function or redshift plsql procedure from console/UI

You have following options as the inputs depends on your application.

1. Redshift query editor : Using the query editor is an easy way to run queries on databases hosted by your Amazon Redshift cluster. After creating your cluster, you can immediately run queries by using the query editor on the Amazon Redshift console. Reference : https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor.html
2. Testing Lambda functions in the console : You can test your Lambda function in the console by invoking your function with a test event. A test event is a JSON input to your function. If your function doesn't require input, the event can be an empty document ({}). Reference : https://docs.aws.amazon.com/lambda/latest/dg/testing-functions.html